Mega Code Archive

 

Categories / MySQL / Insert Delete Update

 

Data Changed by Field Syntax When 123 4567 Is Inserted

Syntax                       Code                Display                              Description   DECIMAL(w,d)                 DECIMAL(5,2)        123.46                               5 digits, 2 decimal places   NUMERIC(w,d)                 NUMERIC(7,4)        123.4567                             Exact fit. (7 digits, 4 decimal places)   DECIMAL(w)                   DECIMAL(9)          123                                  No decimal specification defaults to 0 decimal places.   DECIMAL                      DECIMAL             123                                  Default is 10 digits, 0 decimal places. (10 digits, 7 padded places to left of number)