牛客MySQL-1.27MySQL临时表

最新推荐文章于 2024-10-09 18:19:09 发布

Fancy_Jin

最新推荐文章于 2024-10-09 18:19:09 发布

阅读量102

点赞数

分类专栏： MySQL 文章标签： mysql

原文链接：https://dev.mysql.com/doc/refman/8.0/en/fixed-point-types.html

版权

MySQL 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

本文介绍了SQL中DECIMAL类型的使用，特别是精度和规模的概念。DECIMAL(5,2)允许存储最多5位数字，其中2位为小数，范围从-999.99到999.99。精度表示数值的总位数，而规模则指小数点后的位数。默认情况下，MySQL中未指定精度的DECIMAL将默认为10。如果规模为0，则数值没有小数部分。

摘要由CSDN通过智能技术生成

In a DECIMAL column declaration, the precision and scale can be (and usually is) specified. For example:

salary DECIMAL(5,2)

Standard SQL requires that DECIMAL(5,2) be able to store any value with five digits and two decimals, so values that can be stored in the salary column range from -999.99 to 999.99.In this example, 5 is the precision and 2 is the scale. The precision represents the number of significant digits that are stored for values, and the scale represents the number of digits that can be stored following the decimal point.

In standard SQL, the syntax DECIMAL(M) is equivalent to DECIMAL(M,0). Similarly, the syntax DECIMAL is equivalent to DECIMAL(M,0), where the implementation is permitted to decide the value of M. MySQL supports both of these variant forms of DECIMAL syntax. The default value of M is 10.

If the scale is 0, DECIMAL values contain no decimal point or fractional part.

关注博主即可阅读全文