Insert Delete Update MySQL

  1. Home
  2. MySQL
  3. Insert Delete Update
  4. 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)