正文

DECIMAL Data Type

IP云
IP云V管理员/2 阅读
08/20
小程序：扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序

In MySQL, DECIMAL(M,D) and NUMERIC(M,D) are the same, and both have a precision of exactly M digits.

Leftover Digits Number of Bytes

–
–
–
–

For example,

a DECIMAL(18,9) column has nine digits on either side of the decimal point, so the integer part and the fractional part each require 4 bytes.

A DECIMAL(20,6) column has fourteen integer digits and six fractional digits.

The integer digits require four bytes for nine of the digits and 3 bytes for the remaining five digits.

The six fractional digits require 3 bytes.