{"id":209775,"date":"2022-08-18T15:57:59","date_gmt":"2022-08-18T07:57:59","guid":{"rendered":"https:\/\/www.keaglegz.com\/209775.html"},"modified":"2022-08-18T15:57:59","modified_gmt":"2022-08-18T07:57:59","slug":"mysql%e6%95%b0%e6%8d%ae%e7%b1%bb%e5%9e%8bdecimalmd%e7%9a%84%e8%af%b4%e6%98%8e","status":"publish","type":"post","link":"https:\/\/www.dongwubaike.cn\/fanhao\/209775.html","title":{"rendered":"MySQL\u6570\u636e\u7c7b\u578bdecimal(m,d)\u7684\u8bf4\u660e"},"content":{"rendered":"\n

\u5173\u4e8eMySQL\u6570\u636e\u7c7b\u578bdecimal(m,d)\u7684\u8bf4\u660e\uff0c\u81ea\u5df1\u4eb2\u6d4b\u4e00\u904d\uff1a<\/p>\n

create table decimal_test(
id int auto_increment PRIMARY key,
score decimal(5,2)  — \u53d6\u503c\u8303\u56f4\u662f -999.99 \u5230 999.99
);<\/p>\n

— \u6574\u6570\u7684\u4f4d\u6570\u5fc5\u987b\u5c0f\u4e8e\u7b49\u4e8em-d\uff0c\u4e0d\u7136\u62a5\u9519\u3002\u5c0f\u6570\u7684\u4f4d\u6570\u53ef\u4ee5\u5927\u4e8ed\u4f4d\u3002\u591a\u51fad\u4f4d\u65f6\u4f1a\u505a\u56db\u820d\u4e94\u5165\uff0c\u622a\u53d6\u5230d\u4f4d\u3002
— \u4ee5\u4e0a\u5747\u4e0d\u5305\u62ec\u5c0f\u6570\u70b9\u3001\u7b26\u53f7\u7684\u4f4d\u6570\u3002\u6570\u5b57\u7684\u603b\u957f\u5ea6\u662fm\u4f4d\uff0c\u4fdd\u5b58\u540e\u7684\u5c0f\u6570\u4f4d\u6700\u591a\u662fd\u4f4d\u3002\u5982\u679c\u4fdd\u5b58\u540e\u662f\u6574\u6570\uff0c\u5c0f\u6570\u4f4d\u4e0d\u4f1a\u88650\u3002
— \u4ee5\u4e0b\u6d4b\u8bd5\u7248\u672c\u662f5.7.14<\/p>\n

select  *  from  decimal_test;
— \u6b63\u6570\uff1a
insert into decimal_test(score) VALUES(1.23); — 1.23
insert into decimal_test(score) VALUES(123.45); — 123.45
insert into decimal_test(score) VALUES(123.455); — 123.46
insert into decimal_test(score) VALUES(123.451); — 123.45
insert into decimal_test(score) VALUES(123.451123); — 123.45
insert into decimal_test(score) VALUES(12345.451123); — Out of range value for column ‘score’
insert into decimal_test(score) VALUES(9999.451123); —  Out of range value for column ‘score’
insert into decimal_test(score) VALUES(999.451123234324); — 999.45
insert into decimal_test(score) VALUES(999.999999999); — Out of range value for column ‘score’
insert into decimal_test(score) VALUES(999.99123); — 999.99
— \u8d1f\u6570\uff1a
insert into decimal_test(score) VALUES(-1.23); — -1.23
insert into decimal_test(score) VALUES(-12.34); — -12.34
insert into decimal_test(score) VALUES(-123.45); — -123.45
insert into decimal_test(score) VALUES(-999.45); — -999.45
insert into decimal_test(score) VALUES(-12343); — Out of range value for column ‘score’
insert into decimal_test(score) VALUES(12343); — Out of range value for column ‘score’
insert into decimal_test(score) VALUES(1234); — Out of range value for column ‘score’
insert into decimal_test(score) VALUES(123); — 123
insert into decimal_test(score) VALUES(-123); — -123
insert into decimal_test(score) VALUES(-999.99); — -999.99
insert into decimal_test(score) VALUES(-9990.99); — Out of range value for column ‘score’
insert into decimal_test(score) VALUES(-1234.99); — Out of range value for column ‘score’
insert into decimal_test(score) VALUES(-1234); — Out of range value for column ‘score’<\/p>\n

select  VERSION() ; — 5.7.14<\/p>\n

\"MySQL\u6570\u636e\u7c7b\u578bdecimal(m,d)\u7684\u8bf4\u660e\"<\/a><\/p>\n

\u672c\u6587\u6c38\u4e45\u66f4\u65b0\u94fe\u63a5\u5730\u5740<\/span>\uff1ahttp:\/\/www.linuxidc.com\/Linux\/2018-02\/150736.htm<\/p>\n

\"MySQL\u6570\u636e\u7c7b\u578bdecimal(m,d)\u7684\u8bf4\u660e\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\u5173\u4e8eMySQL\u6570\u636e\u7c7b\u578bdecimal(m,d)\u7684\u8bf4\u660e\uff0c\u81ea\u5df1\u4eb2\u6d4b\u4e00\u904d\uff1acreate table decimal_test(
\nid int auto_increment PRIMARY key,
\nscore decimal(5,2)  — \u53d6\u503c\u8303\u56f4\u662f -999.99 \u5230 999.99
\n);<\/p>\n","protected":false},"author":1,"featured_media":209774,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-209775","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/posts\/209775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/comments?post=209775"}],"version-history":[{"count":0,"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/posts\/209775\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/media\/209774"}],"wp:attachment":[{"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/media?parent=209775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/categories?post=209775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/tags?post=209775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}