MySQL Tutorial/Data Types/Decimal

DECIMAL(7,2)

   <source lang="sql">

mysql> mysql> mysql> CREATE TABLE myTable

   -> (
   ->    ID SMALLINT,
   ->    Price DECIMAL(7,2),
   ->    Weight FLOAT(8,4)
   -> );

Query OK, 0 rows affected (0.05 sec) mysql> mysql> desc myTable; +--------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+--------------+------+-----+---------+-------+ | ID | smallint(6) | YES | | NULL | | | Price | decimal(7,2) | YES | | NULL | | | Weight | float(8,4) | YES | | NULL | | +--------+--------------+------+-----+---------+-------+ 3 rows in set (0.02 sec) mysql> mysql> drop table myTable; Query OK, 0 rows affected (0.00 sec) mysql></source>

DECIMAL[(M[,D])] [UNSIGNED] [ZEROFILL]

A packed exact fixed-point number.

M is the total number of digits.

D is the number of digits after the decimal point.

The decimal point and (for negative numbers) the "-" sign are not counted in M.

The maximum number of digits (M) is 65.

The maximum number of decimals (D) is 30.

If D is omitted, the default is 0.

If M is omitted, the default is 10.

   <source lang="sql">

DEC[(M[,D])] [UNSIGNED] [ZEROFILL], NUMERIC[(M[,D])] [UNSIGNED] [ZEROFILL], FIXED[(M[,D])] [UNSIGNED] [ZEROFILL] are synonyms for DECIMAL.</source>

For inserts into a DECIMAL or integer column

   <source lang="sql">

mysql> mysql> mysql> CREATE TABLE t (d DECIMAL(10,0)); Query OK, 0 rows affected (0.01 sec) mysql> mysql> INSERT INTO t VALUES(2.5),(2.5E0); Query OK, 2 rows affected, 2 warnings (0.00 sec) Records: 2 Duplicates: 0 Warnings: 2 mysql> SELECT d FROM t; +------+ | d | +------+ | 3 | | 3 | +------+ 2 rows in set (0.00 sec) mysql> mysql> drop table t; Query OK, 0 rows affected (0.01 sec) mysql></source>