# MySQL DECIMAL

To define a column whose data type is `DECIMAL`

we use the following syntax:

```
column_name DECIMAL(P, D)
```

In the syntax about:

- P is the
`precision`

that represents the number of significant digits. The range of P is 1 to 65. - D is the
`scale`

that represents the number of digits after the deciamal point. The range of D is 0 to 30. MySQL requires D is less than or equal to P.

Example:

```
cost DECIMAL(10, 2)
```

The `cost`

column can store 10 digits with 2 decimal places. Therefore, the range of `cost`

is from 99999999.99 to -99999999.99