{"id":11402,"date":"2025-06-11T16:32:07","date_gmt":"2025-06-11T08:32:07","guid":{"rendered":"https:\/\/egonlin.com\/?p=11402"},"modified":"2025-06-12T16:23:03","modified_gmt":"2025-06-12T08:23:03","slug":"%e6%95%b0%e6%8d%ae%e7%b1%bb%e5%9e%8b","status":"publish","type":"post","link":"https:\/\/egonlin.com\/?p=11402","title":{"rendered":"\u6570\u636e\u7c7b\u578b"},"content":{"rendered":"<h3>\u4e00 \u4ecb\u7ecd<\/h3>\n<p>\u5b58\u50a8\u5f15\u64ce\u51b3\u5b9a\u4e86\u8868\u7684\u7c7b\u578b\uff0c\u800c\u8868\u5185\u5b58\u653e\u7684\u6570\u636e\u4e5f\u8981\u6709\u4e0d\u540c\u7684\u7c7b\u578b\uff0c\u6bcf\u79cd\u6570\u636e\u7c7b\u578b\u90fd\u6709\u81ea\u5df1\u7684\u5bbd\u5ea6\uff0c\u4f46\u5bbd\u5ea6\u662f\u53ef\u9009\u7684<\/p>\n<p>\u8be6\u7ec6\u53c2\u8003\uff1a<\/p>\n<ul>\n<li>http:\/\/www.runoob.com\/mysql\/mysql-data-types.html<\/li>\n<li>http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/data-type-overview.html<\/li>\n<\/ul>\n<p>mysql\u5e38\u7528\u6570\u636e\u7c7b\u578b\u6982\u89c8<\/p>\n<pre>#1. \u6570\u5b57\uff1a\r\n    \u6574\u578b\uff1atinyinit  int  bigint\r\n    \u5c0f\u6570\uff1a\r\n        float \uff1a\u5728\u4f4d\u6570\u6bd4\u8f83\u77ed\u7684\u60c5\u51b5\u4e0b\u4e0d\u7cbe\u51c6\r\n        double \uff1a\u5728\u4f4d\u6570\u6bd4\u8f83\u957f\u7684\u60c5\u51b5\u4e0b\u4e0d\u7cbe\u51c6\r\n            0.000001230123123123\r\n            \u5b58\u6210\uff1a0.000001230000\r\n\r\n        decimal\uff1a\uff08\u5982\u679c\u7528\u5c0f\u6570\uff0c\u5219\u7528\u63a8\u8350\u4f7f\u7528decimal\uff09\r\n            \u7cbe\u51c6\r\n            \u5185\u90e8\u539f\u7406\u662f\u4ee5\u5b57\u7b26\u4e32\u5f62\u5f0f\u53bb\u5b58\r\n\r\n#2. \u5b57\u7b26\u4e32\uff1a\r\n    char\uff0810\uff09\uff1a\u7b80\u5355\u7c97\u66b4\uff0c\u6d6a\u8d39\u7a7a\u95f4\uff0c\u5b58\u53d6\u901f\u5ea6\u5feb\r\n        root\u5b58\u6210root000000\r\n    varchar\uff1a\u7cbe\u51c6\uff0c\u8282\u7701\u7a7a\u95f4\uff0c\u5b58\u53d6\u901f\u5ea6\u6162\r\n\r\n    sql\u4f18\u5316\uff1a\u521b\u5efa\u8868\u65f6\uff0c\u5b9a\u957f\u7684\u7c7b\u578b\u5f80\u524d\u653e\uff0c\u53d8\u957f\u7684\u5f80\u540e\u653e\r\n                    \u6bd4\u5982\u6027\u522b           \u6bd4\u5982\u5730\u5740\u6216\u63cf\u8ff0\u4fe1\u606f\r\n\r\n    &gt;255\u4e2a\u5b57\u7b26\uff0c\u8d85\u4e86\u5c31\u628a\u6587\u4ef6\u8def\u5f84\u5b58\u653e\u5230\u6570\u636e\u5e93\u4e2d\u3002\r\n            \u6bd4\u5982\u56fe\u7247\uff0c\u89c6\u9891\u7b49\u627e\u4e00\u4e2a\u6587\u4ef6\u670d\u52a1\u5668\uff0c\u6570\u636e\u5e93\u4e2d\u53ea\u5b58\u8def\u5f84\u6216url\u3002\r\n\r\n\r\n\r\n#3. \u65f6\u95f4\u7c7b\u578b\uff1a\r\n    \u6700\u5e38\u7528\uff1adatetime\r\n\r\n\r\n#4. \u679a\u4e3e\u7c7b\u578b\u4e0e\u96c6\u5408\u7c7b\u578b<\/pre>\n<h3>\u4e8c \u6570\u503c\u7c7b\u578b<\/h3>\n<p><strong>1\u3001\u6574\u6570\u7c7b\u578b<\/strong><\/p>\n<p>\u6574\u6570\u7c7b\u578b\uff1aTINYINT SMALLINT MEDIUMINT INT BIGINT<\/p>\n<p>\u4f5c\u7528\uff1a\u5b58\u50a8\u5e74\u9f84\uff0c\u7b49\u7ea7\uff0cid\uff0c\u5404\u79cd\u53f7\u7801\u7b49<\/p>\n<pre>========================================\r\n        tinyint[(m)] [unsigned] [zerofill]\r\n\r\n            \u5c0f\u6574\u6570\uff0c\u6570\u636e\u7c7b\u578b\u7528\u4e8e\u4fdd\u5b58\u4e00\u4e9b\u8303\u56f4\u7684\u6574\u6570\u6570\u503c\u8303\u56f4\uff1a\r\n            \u6709\u7b26\u53f7\uff1a\r\n                -128 \uff5e 127\r\n            \u65e0\u7b26\u53f7\uff1a\r\n                0 \uff5e 255\r\n\r\n            PS\uff1a MySQL\u4e2d\u65e0\u5e03\u5c14\u503c\uff0c\u4f7f\u7528tinyint(1)\u6784\u9020\u3002\r\n\r\n\r\n\r\n========================================\r\n        int[(m)][unsigned][zerofill]\r\n\r\n            \u6574\u6570\uff0c\u6570\u636e\u7c7b\u578b\u7528\u4e8e\u4fdd\u5b58\u4e00\u4e9b\u8303\u56f4\u7684\u6574\u6570\u6570\u503c\u8303\u56f4\uff1a\r\n            \u6709\u7b26\u53f7\uff1a\r\n                    -2147483648 \uff5e 2147483647\r\n            \u65e0\u7b26\u53f7\uff1a\r\n                    0 \uff5e 4294967295\r\n\r\n\r\n\r\n========================================\r\n        bigint[(m)][unsigned][zerofill]\r\n            \u5927\u6574\u6570\uff0c\u6570\u636e\u7c7b\u578b\u7528\u4e8e\u4fdd\u5b58\u4e00\u4e9b\u8303\u56f4\u7684\u6574\u6570\u6570\u503c\u8303\u56f4\uff1a\r\n            \u6709\u7b26\u53f7\uff1a\r\n                    -9223372036854775808 \uff5e 9223372036854775807\r\n            \u65e0\u7b26\u53f7\uff1a\r\n                    0  \uff5e  18446744073709551615<\/pre>\n<p>\u9a8c\u8bc1<\/p>\n<pre>=========\u6709\u7b26\u53f7\u548c\u65e0\u7b26\u53f7tinyint==========\r\n#tinyint\u9ed8\u8ba4\u4e3a\u6709\u7b26\u53f7\r\nMariaDB [db1]&gt; create table t1(x tinyint); #\u9ed8\u8ba4\u4e3a\u6709\u7b26\u53f7\uff0c\u5373\u6570\u5b57\u524d\u6709\u6b63\u8d1f\u53f7\r\nMariaDB [db1]&gt; desc t1;\r\nMariaDB [db1]&gt; insert into t1 values\r\n    -&gt; (-129),\r\n    -&gt; (-128),\r\n    -&gt; (127),\r\n    -&gt; (128);\r\nMariaDB [db1]&gt; select * from t1;\r\n+------+\r\n| x    |\r\n+------+\r\n| -128 | #-129\u5b58\u6210\u4e86-128\r\n| -128 | #\u6709\u7b26\u53f7\uff0c\u6700\u5c0f\u503c\u4e3a-128\r\n|  127 | #\u6709\u7b26\u53f7\uff0c\u6700\u5927\u503c127\r\n|  127 | #128\u5b58\u6210\u4e86127\r\n+------+\r\n\r\n\r\n\r\n#\u8bbe\u7f6e\u65e0\u7b26\u53f7tinyint\r\nMariaDB [db1]&gt; create table t2(x tinyint unsigned);\r\nMariaDB [db1]&gt; insert into t2 values\r\n    -&gt; (-1),\r\n    -&gt; (0),\r\n    -&gt; (255),\r\n    -&gt; (256);\r\nMariaDB [db1]&gt; select * from t2;\r\n+------+\r\n| x    |\r\n+------+\r\n|    0 | -1\u5b58\u6210\u4e860\r\n|    0 | #\u65e0\u7b26\u53f7\uff0c\u6700\u5c0f\u503c\u4e3a0\r\n|  255 | #\u65e0\u7b26\u53f7\uff0c\u6700\u5927\u503c\u4e3a255\r\n|  255 | #256\u5b58\u6210\u4e86255\r\n+------+\r\n\r\n\r\n\r\n============\u6709\u7b26\u53f7\u548c\u65e0\u7b26\u53f7int=============\r\n#int\u9ed8\u8ba4\u4e3a\u6709\u7b26\u53f7\r\nMariaDB [db1]&gt; create table t3(x int); #\u9ed8\u8ba4\u4e3a\u6709\u7b26\u53f7\u6574\u6570\r\nMariaDB [db1]&gt; insert into t3 values\r\n    -&gt; (-2147483649),\r\n    -&gt; (-2147483648),\r\n    -&gt; (2147483647),\r\n    -&gt; (2147483648);\r\nMariaDB [db1]&gt; select * from t3;\r\n+-------------+\r\n| x           |\r\n+-------------+\r\n| -2147483648 | #-2147483649\u5b58\u6210\u4e86-2147483648\r\n| -2147483648 | #\u6709\u7b26\u53f7\uff0c\u6700\u5c0f\u503c\u4e3a-2147483648\r\n|  2147483647 | #\u6709\u7b26\u53f7\uff0c\u6700\u5927\u503c\u4e3a2147483647\r\n|  2147483647 | #2147483648\u5b58\u6210\u4e862147483647\r\n+-------------+\r\n\r\n\r\n\r\n#\u8bbe\u7f6e\u65e0\u7b26\u53f7int\r\nMariaDB [db1]&gt; create table t4(x int unsigned);\r\nMariaDB [db1]&gt; insert into t4 values\r\n    -&gt; (-1),\r\n    -&gt; (0),\r\n    -&gt; (4294967295),\r\n    -&gt; (4294967296);\r\nMariaDB [db1]&gt; select * from t4;\r\n+------------+\r\n| x          |\r\n+------------+\r\n|          0 | #-1\u5b58\u6210\u4e860\r\n|          0 | #\u65e0\u7b26\u53f7\uff0c\u6700\u5c0f\u503c\u4e3a0\r\n| 4294967295 | #\u65e0\u7b26\u53f7\uff0c\u6700\u5927\u503c\u4e3a4294967295\r\n| 4294967295 | #4294967296\u5b58\u6210\u4e864294967295\r\n+------------+\r\n\r\n\r\n\r\n\r\n==============\u6709\u7b26\u53f7\u548c\u65e0\u7b26\u53f7bigint=============\r\nMariaDB [db1]&gt; create table t6(x bigint);\r\nMariaDB [db1]&gt; insert into t5 values  \r\n    -&gt; (-9223372036854775809),\r\n    -&gt; (-9223372036854775808),\r\n    -&gt; (9223372036854775807),\r\n    -&gt; (9223372036854775808);\r\n\r\nMariaDB [db1]&gt; select * from t5;\r\n+----------------------+\r\n| x                    |\r\n+----------------------+\r\n| -9223372036854775808 |\r\n| -9223372036854775808 |\r\n|  9223372036854775807 |\r\n|  9223372036854775807 |\r\n+----------------------+\r\n\r\n\r\n\r\nMariaDB [db1]&gt; create table t6(x bigint unsigned);\r\nMariaDB [db1]&gt; insert into t6 values  \r\n    -&gt; (-1),\r\n    -&gt; (0),\r\n    -&gt; (18446744073709551615),\r\n    -&gt; (18446744073709551616);\r\n\r\nMariaDB [db1]&gt; select * from t6;\r\n+----------------------+\r\n| x                    |\r\n+----------------------+\r\n|                    0 |\r\n|                    0 |\r\n| 18446744073709551615 |\r\n| 18446744073709551615 |\r\n+----------------------+\r\n\r\n\r\n\r\n\r\n======\u7528zerofill\u6d4b\u8bd5\u6574\u6570\u7c7b\u578b\u7684\u663e\u793a\u5bbd\u5ea6=============\r\nMariaDB [db1]&gt; create table t7(x int(3) zerofill);\r\nMariaDB [db1]&gt; insert into t7 values\r\n    -&gt; (1),\r\n    -&gt; (11),\r\n    -&gt; (111),\r\n    -&gt; (1111);\r\nMariaDB [db1]&gt; select * from t7;\r\n+------+\r\n| x    |\r\n+------+\r\n|  001 |\r\n|  011 |\r\n|  111 |\r\n| 1111 | #\u8d85\u8fc7\u5bbd\u5ea6\u9650\u5236\u4ecd\u7136\u53ef\u4ee5\u5b58\r\n+------+\r\n\r\n\r\n<\/pre>\n<p>\u6ce8\u610f\uff1a\u4e3a\u8be5\u7c7b\u578b\u6307\u5b9a\u5bbd\u5ea6\u65f6\uff0c\u4ec5\u4ec5\u53ea\u662f\u6307\u5b9a\u67e5\u8be2\u7ed3\u679c\u7684\u663e\u793a\u5bbd\u5ea6\uff0c\u4e0e\u5b58\u50a8\u8303\u56f4\u65e0\u5173\uff0c\u5b58\u50a8\u8303\u56f4\u5982\u4e0b<\/p>\n<p>\u5176\u5b9e\u6211\u4eec\u5b8c\u5168\u6ca1\u5fc5\u8981\u4e3a\u6574\u6570\u7c7b\u578b\u6307\u5b9a\u663e\u793a\u5bbd\u5ea6\uff0c\u4f7f\u7528\u9ed8\u8ba4\u7684\u5c31\u53ef\u4ee5\u4e86<\/p>\n<p>\u9ed8\u8ba4\u7684\u663e\u793a\u5bbd\u5ea6\uff0c\u90fd\u662f\u5728\u6700\u5927\u503c\u7684\u57fa\u7840\u4e0a\u52a01<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/egonlin.com\/wp-content\/uploads\/2025\/06\/1036857-20170801181433755-146301178.png'><img class=\"lazyload lazyload-style-2\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" class=\"alignnone size-full wp-image-11403\" data-original=\"https:\/\/egonlin.com\/wp-content\/uploads\/2025\/06\/1036857-20170801181433755-146301178.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" width=\"730\" height=\"638\" \/><\/div><\/p>\n<p>\bint\u7684\u5b58\u50a8\u5bbd\u5ea6\u662f4\u4e2aBytes\uff0c\u537332\u4e2abit\uff0c\u53732**32<\/p>\n<p>\u65e0\u7b26\u53f7\u6700\u5927\u503c\u4e3a\uff1a4294967296-1<\/p>\n<p>\u6709\u7b26\u53f7\u6700\u5927\u503c\uff1a2147483648-1<\/p>\n<p>\u6709\u7b26\u53f7\u548c\u65e0\u7b26\u53f7\u7684\u6700\u5927\u6570\u5b57\u9700\u8981\u7684\u663e\u793a\u5bbd\u5ea6\u5747\u4e3a10\uff0c\u800c\u9488\u5bf9\u6709\u7b26\u53f7\u7684\u6700\u5c0f\u503c\u5219\u9700\u898111\u4f4d\u624d\u80fd\u663e\u793a\u5b8c\u5168\uff0c\u6240\u4ee5int\u7c7b\u578b\u9ed8\u8ba4\u7684\u663e\u793a\u5bbd\u5ea6\u4e3a11\u662f\u975e\u5e38\u5408\u7406\u7684<\/p>\n<p>\u6700\u540e\uff1a\u6574\u5f62\u7c7b\u578b\uff0c\u5176\u5b9e\u6ca1\u6709\u5fc5\u8981\u6307\u5b9a\u663e\u793a\u5bbd\u5ea6\uff0c\u4f7f\u7528\u9ed8\u8ba4\u7684\u5c31ok<\/p>\n<p>&nbsp;<\/p>\n<p><strong>2\u3001\u6d6e\u70b9\u578b<\/strong><\/p>\n<p>\u5b9a\u70b9\u6570\u7c7b\u578b \u00a0DEC\u7b49\u540c\u4e8eDECIMAL<\/p>\n<p>\u6d6e\u70b9\u7c7b\u578b\uff1aFLOAT DOUBLE<\/p>\n<p>\u4f5c\u7528\uff1a\u5b58\u50a8\u85aa\u8d44\u3001\u8eab\u9ad8\u3001\u4f53\u91cd\u3001\u4f53\u8d28\u53c2\u6570\u7b49<\/p>\n<pre>======================================\r\n#FLOAT[(M,D)] [UNSIGNED] [ZEROFILL]\r\n\r\n\u5b9a\u4e49\uff1a\r\n        \u5355\u7cbe\u5ea6\u6d6e\u70b9\u6570\uff08\u975e\u51c6\u786e\u5c0f\u6570\u503c\uff09\uff0cm\u662f\u6570\u5b57\u603b\u4e2a\u6570\uff0cd\u662f\u5c0f\u6570\u70b9\u540e\u4e2a\u6570\u3002m\u6700\u5927\u503c\u4e3a255\uff0cd\u6700\u5927\u503c\u4e3a30\r\n\r\n\u6709\u7b26\u53f7\uff1a\r\n           -3.402823466E+38 to -1.175494351E-38,\r\n           1.175494351E-38 to 3.402823466E+38\r\n\u65e0\u7b26\u53f7\uff1a\r\n           1.175494351E-38 to 3.402823466E+38\r\n\r\n\r\n\u7cbe\u786e\u5ea6\uff1a \r\n           **** \u968f\u7740\u5c0f\u6570\u7684\u589e\u591a\uff0c\u7cbe\u5ea6\u53d8\u5f97\u4e0d\u51c6\u786e ****\r\n\r\n\r\n======================================\r\n#DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]\r\n\r\n\u5b9a\u4e49\uff1a\r\n           \u53cc\u7cbe\u5ea6\u6d6e\u70b9\u6570\uff08\u975e\u51c6\u786e\u5c0f\u6570\u503c\uff09\uff0cm\u662f\u6570\u5b57\u603b\u4e2a\u6570\uff0cd\u662f\u5c0f\u6570\u70b9\u540e\u4e2a\u6570\u3002m\u6700\u5927\u503c\u4e3a255\uff0cd\u6700\u5927\u503c\u4e3a30\r\n\r\n\u6709\u7b26\u53f7\uff1a\r\n           -1.7976931348623157E+308 to -2.2250738585072014E-308\r\n           2.2250738585072014E-308 to 1.7976931348623157E+308\r\n\r\n\u65e0\u7b26\u53f7\uff1a\r\n           2.2250738585072014E-308 to 1.7976931348623157E+308\r\n            \r\n\u7cbe\u786e\u5ea6\uff1a\r\n           ****\u968f\u7740\u5c0f\u6570\u7684\u589e\u591a\uff0c\u7cbe\u5ea6\u6bd4float\u8981\u9ad8\uff0c\u4f46\u4e5f\u4f1a\u53d8\u5f97\u4e0d\u51c6\u786e ****\r\n\r\n======================================\r\ndecimal[(m[,d])] [unsigned] [zerofill]\r\n\r\n\u5b9a\u4e49\uff1a\r\n          \u51c6\u786e\u7684\u5c0f\u6570\u503c\uff0cm\u662f\u6570\u5b57\u603b\u4e2a\u6570\uff08\u8d1f\u53f7\u4e0d\u7b97\uff09\uff0cd\u662f\u5c0f\u6570\u70b9\u540e\u4e2a\u6570\u3002 m\u6700\u5927\u503c\u4e3a65\uff0cd\u6700\u5927\u503c\u4e3a30\u3002\r\n\r\n\r\n\u7cbe\u786e\u5ea6\uff1a\r\n           **** \u968f\u7740\u5c0f\u6570\u7684\u589e\u591a\uff0c\u7cbe\u5ea6\u59cb\u7ec8\u51c6\u786e ****\r\n           \u5bf9\u4e8e\u7cbe\u786e\u6570\u503c\u8ba1\u7b97\u65f6\u9700\u8981\u7528\u6b64\u7c7b\u578b\r\n           decaimal\u80fd\u591f\u5b58\u50a8\u7cbe\u786e\u503c\u7684\u539f\u56e0\u5728\u4e8e\u5176\u5185\u90e8\u6309\u7167\u5b57\u7b26\u4e32\u5b58\u50a8\u3002<\/pre>\n<p><strong>\u6d6e\u70b9\u578b<\/strong><\/p>\n<pre>mysql&gt; create table t1(x float(256,31));\r\nERROR 1425 (42000): Too big scale 31 specified for column 'x'. Maximum is 30.\r\nmysql&gt; create table t1(x float(256,30));\r\nERROR 1439 (42000): Display width out of range for column 'x' (max = 255)\r\nmysql&gt; create table t1(x float(255,30)); #\u5efa\u8868\u6210\u529f\r\nQuery OK, 0 rows affected (0.02 sec)\r\n\r\nmysql&gt; create table t2(x double(255,30)); #\u5efa\u8868\u6210\u529f\r\nQuery OK, 0 rows affected (0.02 sec)\r\n\r\nmysql&gt; create table t3(x decimal(66,31));\r\nERROR 1425 (42000): Too big scale 31 specified for column 'x'. Maximum is 30.\r\nmysql&gt; create table t3(x decimal(66,30));\r\nERROR 1426 (42000): Too-big precision 66 specified for 'x'. Maximum is 65.\r\nmysql&gt; create table t3(x decimal(65,30)); #\u5efa\u8868\u6210\u529f\r\nQuery OK, 0 rows affected (0.02 sec)\r\n\r\nmysql&gt; show tables;\r\n+---------------+\r\n| Tables_in_db1 |\r\n+---------------+\r\n| t1            |\r\n| t2            |\r\n| t3            |\r\n+---------------+\r\n3 rows in set (0.00 sec)\r\n\r\n\r\n\r\nmysql&gt; insert into t1 values(1.1111111111111111111111111111111); #\u5c0f\u6570\u70b9\u540e31\u4e2a1\r\nQuery OK, 1 row affected (0.01 sec)\r\n\r\nmysql&gt; insert into t2 values(1.1111111111111111111111111111111);\r\nQuery OK, 1 row affected (0.00 sec)\r\n\r\nmysql&gt; insert into t3 values(1.1111111111111111111111111111111);\r\nQuery OK, 1 row affected, 1 warning (0.01 sec)\r\n\r\nmysql&gt; select * from t1; #\u968f\u7740\u5c0f\u6570\u7684\u589e\u591a\uff0c\u7cbe\u5ea6\u5f00\u59cb\u4e0d\u51c6\u786e\r\n+----------------------------------+\r\n| x                                |\r\n+----------------------------------+\r\n| 1.111111164093017600000000000000 |\r\n+----------------------------------+\r\n1 row in set (0.00 sec)\r\n\r\nmysql&gt; select * from t2; #\u7cbe\u5ea6\u6bd4float\u8981\u51c6\u786e\u70b9\uff0c\u4f46\u968f\u7740\u5c0f\u6570\u7684\u589e\u591a\uff0c\u540c\u6837\u53d8\u5f97\u4e0d\u51c6\u786e\r\n+----------------------------------+\r\n| x                                |\r\n+----------------------------------+\r\n| 1.111111111111111200000000000000 |\r\n+----------------------------------+\r\n1 row in set (0.00 sec)\r\n\r\nmysql&gt; select * from t3; #\u7cbe\u5ea6\u59cb\u7ec8\u51c6\u786e,d\u4e3a30\uff0c\u4e8e\u662f\u53ea\u7559\u4e8630\u4f4d\u5c0f\u6570\r\n+----------------------------------+\r\n| x                                |\r\n+----------------------------------+\r\n| 1.111111111111111111111111111111 |\r\n+----------------------------------+\r\n1 row in set (0.00 sec)\r\n\r\n<\/pre>\n<p><strong>3\u3001\u4f4d\u7c7b\u578b\uff08\u4e86\u89e3\uff09<\/strong><br \/>\n<\/p><div id=\"rml_readmorelogin_placeholder\" style=\"position:relative;\"><div id=\"rml_fade_content\" style=\"position: absolute;\r\ntop:-10em;\r\nwidth:100%;\r\nheight:10em;\r\nbackground: -webkit-linear-gradient(rgba(255, 255, 255, 0) 0%,#ffffff 100%);\r\nbackground-image: -moz-linear-gradient(rgba(255, 255, 255, 0) 0%,#ffffff 100%);\r\nbackground-image: -o-linear-gradient(rgba(255, 255, 255, 0) 0%,#ffffff 100%);\r\nbackground-image: linear-gradient(rgba(255, 255, 255, 0) 0%,#ffffff 100%);\r\nbackground-image: -ms-linear-gradient(rgba(255, 255, 255, 0) 0%,#ffffff 100%);\"><\/div><div class=\"wpf-controller aru_rml_from_in_post\" style=\"background-color:#eeeeee;border:5px solid #cce6ff;\" id=\"ARU_ReadMoreLogin_ReadMoreLoginController\"><h2 id=\"Header\">\u67e5\u770b\u66f4\u591a<\/h2><div id=\"Message\"><p>\u8054\u7cfb\u7ba1\u7406\u5458\u5fae\u4fe1tutu19192010\uff0c\u6ce8\u518c\u8d26\u53f7<\/p>\n<\/div><div id=\"StatusBarHeader\"><\/div><form id=\"ARU_ReadMoreLogin_ReadMoreLoginController\"><input name=\"post_id\" value=\"11402\" type=\"hidden\"\/><input name=\"_init_callback\" value=\"InitLogin\" type=\"hidden\"\/><input name=\"post_id\" value=\"11402\" type=\"hidden\"\/><input name=\"rt_ype\" value=\"1\" type=\"hidden\"\/><input name=\"nonce\" value=\"39cdfbc77b\" type=\"hidden\"\/><input name=\"_wpnonce\" value=\"2d1dcda414\" type=\"hidden\"\/><input name=\"_controller\" value=\"ARU_ReadMoreLogin\\ReadMoreLoginController\" type=\"hidden\"\/><input name=\"_proxy_controller\" value=\"ARU_ReadMoreLogin\\ReadMoreLoginController\" type=\"hidden\"\/><input name=\"_view\" value=\"ARU_ReadMoreLogin\\ReadMoreLoginView\" type=\"hidden\"\/><table class=\"wpf-table-placeholder\"><tbody class=\"wpf-table-placeholder\"><tr class=\"wpf-table-placeholder\"><td class=\"wpf-table-placeholder-input\" width=\"400px\"><table class=\"wpf-table-placeholder\"><tbody class=\"wpf-table-placeholder\"><tr class=\"wpf-table-placeholder\"><th class=\"wpf-table-placeholder-input\"><label class=\"wpf-label\">Username:<\/label><\/th><\/tr><tr class=\"wpf-table-placeholder\"><td class=\"wpf-table-placeholder-input\"><input class=\"regular-text text_input\" name=\"username\" value=\"\" type=\"text\"\/><\/td><\/tr><tr class=\"wpf-table-placeholder\"><th class=\"wpf-table-placeholder-input\"><label class=\"wpf-label\">Password:<\/label><\/th><\/tr><tr class=\"wpf-table-placeholder\"><td class=\"wpf-table-placeholder-input\"><input class=\"regular-text text_input\" name=\"password\" value=\"\" type=\"password\"\/><\/td><\/tr><\/tbody><\/table><p class=\"wpf-table-placeholder submit\"><button class=\"wp_plugin_framework_ajax_button\" type=\"button\" style=\"background-color:#4D90FE;;color:#ffffff;;border:1px solid #3079ed;\" name=\"_event\" value=\"ButtonLogin\">Log in<\/button><\/p><\/td><td class=\"wpf-table-placeholder-input\"><\/td><\/tr><\/tbody><\/table><\/form><div id=\"ButtonStartRegister\"><a href=\"https:\/\/egonlin.com\/wp-login.php?action=register\">Register<\/a><\/div><div id=\"Link1\"><a href=\"https:\/\/egonlin.com\/wp-login.php?action=lostpassword\">Forgotten username or password?<\/a><\/div><div id=\"StatusBarFooter\"><\/div><\/div><\/div><div id=aru_remaining_content><\/div>","protected":false},"excerpt":{"rendered":"<p>\u4e00 \u4ecb\u7ecd \u5b58\u50a8\u5f15\u64ce\u51b3\u5b9a\u4e86\u8868\u7684\u7c7b\u578b\uff0c\u800c\u8868\u5185\u5b58\u653e\u7684\u6570\u636e\u4e5f\u8981\u6709\u4e0d\u540c\u7684\u7c7b\u578b\uff0c\u6bcf\u79cd\u6570\u636e\u7c7b\u578b\u90fd\u6709\u81ea\u5df1\u7684\u5bbd\u5ea6\uff0c\u4f46\u5bbd\u5ea6\u662f\u53ef\u9009\u7684 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts\/11402"}],"collection":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11402"}],"version-history":[{"count":7,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts\/11402\/revisions"}],"predecessor-version":[{"id":11528,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts\/11402\/revisions\/11528"}],"wp:attachment":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}