Decimal « Data Type « SQL / MySQL






  1. SQL / MySQL
  2. Data Type
  3. Decimal
1.Decimal and Numeric Data Field Syntax When 123.4567 Is Inserted
2.NUMERIC, DEC Synonym for DECIMAL
3.DECIMAL(p, s) Fixed-point number, saved as a character string;
4.DECIMAL(4,2) for price
5.Insert value to a decimal value column
6.DECIMAL(7,2)
7.DECIMAL(7,2) ZEROFILL NOT NULL
8.Update decimal value
9.Decimal default value