# Fixed-Point Data Types
__*DECIMAL data type*__
+ For exact precision: integers, decimals, or both
+ Data Type:
  + `DECIMAL`:
    + Fixed decimal
    + Maintain accuracy
+ Examples:
  + Denotes currency values: `cost DECIMAL (10,2)` 
  + Sample value output: `385.72` 

------------------------------------------------------------
- TiDB supports all fixed-point types of MySQL, including DECIMAL and NUMERIC

- column Description:
- Total number of digits in M
- Number of decimal places in D
- UNSIGNED is an unsigned number, or a signed number if this is not added
- ZEROFILL zero-padding ID. If there is this identifier, TiDB will automatically add the UNSIGNED logo to the type

- DECIMAL type
  - Fixed-point number, alias NUMERIC. M is the total number of numeric digits (precision) (integer+decimal places), and D is the number of digits after the decimal point (scale). The decimal point and - (negative) sign are not included in M. If D is 0, the value has no decimal or fractional part. If D is omitted, the default is 0. If M is omitted, the default is 10.
```
DECIMAL[(M[,D])] [UNSIGNED] [ZEROFILL]
NUMERIC[(M[,D])] [UNSIGNED] [ZEROFILL]
```