M，D确切地代表十进制(M，D)是什么意思? [英] What does M,D mean in decimal(M,D) exactly?

问题描述

有人知道吗?

推荐答案

为

M是最大位数( 精确).范围是1到65. (旧版本的MySQL允许 范围从1到254.)

M is the maximum number of digits (the precision). It has a range of 1 to 65. (Older versions of MySQL allowed a range of 1 to 254.)

D是右边的数字 小数点的位数(小数位数).它 范围是0到30，并且不能为 大于M.

D is the number of digits to the right of the decimal point (the scale). It has a range of 0 to 30 and must be no larger than M.

所以M代表最大值"(总位数)，D代表十进制"(小数点右边的位数).

So M stands for Maximum (number of digits overall), D stands for Decimals (number of digits to the right of the decimal point).

这篇关于M，D确切地代表十进制(M，D)是什么意思?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！