{"id":31,"date":"2020-12-28T19:07:53","date_gmt":"2020-12-28T11:07:53","guid":{"rendered":"https:\/\/www.52dixiaowo.com\/database\/?p=31"},"modified":"2020-12-28T19:07:54","modified_gmt":"2020-12-28T11:07:54","slug":"mysql-%e6%95%b0%e6%8d%ae%e7%b1%bb%e5%9e%8b","status":"publish","type":"post","link":"https:\/\/www.52dixiaowo.com\/db\/post-31.html","title":{"rendered":"mysql \u6570\u636e\u7c7b\u578b"},"content":{"rendered":"\n<h5>\u5e38\u7528\u7684\u6570\u636e\u7c7b\u578b\u67093\u79cd\uff0c\u6570\u503c\uff0c\u65e5\u671f\u65f6\u95f4\uff0c\u5b57\u7b26\u4e32\u7c7b\u578b<\/h5>\n\n\n\n<h5>1.\u6570\u503c\u7c7b\u578b<\/h5>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>\u7c7b\u578b<\/th><th>\u5927\u5c0f<\/th><th>\u8303\u56f4\uff08\u6709\u7b26\u53f7\uff09<\/th><th>\u8303\u56f4\uff08\u65e0\u7b26\u53f7\uff09<\/th><th>\u7528\u9014<\/th><\/tr><tr><td>TINYINT<\/td><td>1 byte<\/td><td>(-128\uff0c127)<\/td><td>(0\uff0c255)<\/td><td>\u5c0f\u6574\u6570\u503c<\/td><\/tr><tr><td>SMALLINT<\/td><td>2 bytes<\/td><td>(-32 768\uff0c32 767)<\/td><td>(0\uff0c65 535)<\/td><td>\u5927\u6574\u6570\u503c<\/td><\/tr><tr><td>MEDIUMINT<\/td><td>3 bytes<\/td><td>(-8 388 608\uff0c8 388 607)<\/td><td>(0\uff0c16 777 215)<\/td><td>\u5927\u6574\u6570\u503c<\/td><\/tr><tr><td>INT\u6216INTEGER<\/td><td>4 bytes<\/td><td>(-2 147 483 648\uff0c2 147 483 647)<\/td><td>(0\uff0c4 294 967 295)<\/td><td>\u5927\u6574\u6570\u503c<\/td><\/tr><tr><td>BIGINT<\/td><td>8 bytes<\/td><td>(-9,223,372,036,854,775,808\uff0c9 223 372 036 854 775 807)<\/td><td>(0\uff0c18 446 744 073 709 551 615)<\/td><td>\u6781\u5927\u6574\u6570\u503c<\/td><\/tr><tr><td>FLOAT<\/td><td>4 bytes<\/td><td>(-3.402 823 466 E+38\uff0c-1.175 494 351 E-38)\uff0c0\uff0c(1.175 494 351 E-38\uff0c3.402 823 466 351 E+38)<\/td><td>0\uff0c(1.175 494 351 E-38\uff0c3.402 823 466 E+38)<\/td><td>\u5355\u7cbe\u5ea6<br>\u6d6e\u70b9\u6570\u503c<\/td><\/tr><tr><td>DOUBLE<\/td><td>8 bytes<\/td><td>(-1.797 693 134 862 315 7 E+308\uff0c-2.225 073 858 507 201 4 E-308)\uff0c0\uff0c(2.225 073 858 507 201 4 E-308\uff0c1.797 693 134 862 315 7 E+308)<\/td><td>0\uff0c(2.225 073 858 507 201 4 E-308\uff0c1.797 693 134 862 315 7 E+308)<\/td><td>\u53cc\u7cbe\u5ea6<br>\u6d6e\u70b9\u6570\u503c<\/td><\/tr><tr><td>DECIMAL<\/td><td>\u5bf9DECIMAL(M,D) \uff0c\u5982\u679cM&gt;D\uff0c\u4e3aM+2\u5426\u5219\u4e3aD+2<\/td><td>\u4f9d\u8d56\u4e8eM\u548cD\u7684\u503c<\/td><td>\u4f9d\u8d56\u4e8eM\u548cD\u7684\u503c<\/td><td>\u5c0f\u6570\u503c<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h5>2.\u65e5\u671f\u548c\u65f6\u95f4\u7c7b\u578b<\/h5>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>\u7c7b\u578b<\/th><th>\u5927\u5c0f<br>( bytes)<\/th><th>\u8303\u56f4<\/th><th>\u683c\u5f0f<\/th><th>\u7528\u9014<\/th><\/tr><tr><td>DATE<\/td><td>3<\/td><td>1000-01-01\/9999-12-31<\/td><td>YYYY-MM-DD<\/td><td>\u65e5\u671f\u503c<\/td><\/tr><tr><td>TIME<\/td><td>3<\/td><td>&#8216;-838:59:59&#8217;\/&#8217;838:59:59&#8217;<\/td><td>HH:MM:SS<\/td><td>\u65f6\u95f4\u503c\u6216\u6301\u7eed\u65f6\u95f4<\/td><\/tr><tr><td>YEAR<\/td><td>1<\/td><td>1901\/2155<\/td><td>YYYY<\/td><td>\u5e74\u4efd\u503c<\/td><\/tr><tr><td>DATETIME<\/td><td>8<\/td><td>1000-01-01 00:00:00\/9999-12-31 23:59:59<\/td><td>YYYY-MM-DD HH:MM:SS<\/td><td>\u6df7\u5408\u65e5\u671f\u548c\u65f6\u95f4\u503c<\/td><\/tr><tr><td>TIMESTAMP<\/td><td>4<\/td><td>1970-01-01 00:00:00\/2038\u7ed3\u675f\u65f6\u95f4\u662f\u7b2c&nbsp;<strong>2147483647<\/strong>&nbsp;\u79d2\uff0c\u5317\u4eac\u65f6\u95f4&nbsp;<strong>2038-1-19 11:14:07<\/strong>\uff0c\u683c\u6797\u5c3c\u6cbb\u65f6\u95f4 2038\u5e741\u670819\u65e5 \u51cc\u6668 03:14:07<\/td><td>YYYYMMDD HHMMSS<\/td><td>\u6df7\u5408\u65e5\u671f\u548c\u65f6\u95f4\u503c\uff0c\u65f6\u95f4\u6233<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h5>3.\u5b57\u7b26\u4e32\u7c7b\u578b<\/h5>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>\u7c7b\u578b<\/th><th>\u5927\u5c0f<\/th><th>\u7528\u9014<\/th><\/tr><tr><td>CHAR<\/td><td>0-255 bytes<\/td><td>\u5b9a\u957f\u5b57\u7b26\u4e32<\/td><\/tr><tr><td>VARCHAR<\/td><td>0-65535 bytes<\/td><td>\u53d8\u957f\u5b57\u7b26\u4e32<\/td><\/tr><tr><td>TINYBLOB<\/td><td>0-255 bytes<\/td><td>\u4e0d\u8d85\u8fc7 255 \u4e2a\u5b57\u7b26\u7684\u4e8c\u8fdb\u5236\u5b57\u7b26\u4e32<\/td><\/tr><tr><td>TINYTEXT<\/td><td>0-255 bytes<\/td><td>\u77ed\u6587\u672c\u5b57\u7b26\u4e32<\/td><\/tr><tr><td>BLOB<\/td><td>0-65 535 bytes<\/td><td>\u4e8c\u8fdb\u5236\u5f62\u5f0f\u7684\u957f\u6587\u672c\u6570\u636e<\/td><\/tr><tr><td>TEXT<\/td><td>0-65 535 bytes<\/td><td>\u957f\u6587\u672c\u6570\u636e<\/td><\/tr><tr><td>MEDIUMBLOB<\/td><td>0-16 777 215 bytes<\/td><td>\u4e8c\u8fdb\u5236\u5f62\u5f0f\u7684\u4e2d\u7b49\u957f\u5ea6\u6587\u672c\u6570\u636e<\/td><\/tr><tr><td>MEDIUMTEXT<\/td><td>0-16 777 215 bytes<\/td><td>\u4e2d\u7b49\u957f\u5ea6\u6587\u672c\u6570\u636e<\/td><\/tr><tr><td>LONGBLOB<\/td><td>0-4 294 967 295 bytes<\/td><td>\u4e8c\u8fdb\u5236\u5f62\u5f0f\u7684\u6781\u5927\u6587\u672c\u6570\u636e<\/td><\/tr><tr><td>LONGTEXT<\/td><td>0-4 294 967 295 bytes<\/td><td>\u6781\u5927\u6587\u672c\u6570\u636e<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h5>4.\u6570\u636e\u7c7b\u578b\u5982\u4f55\u9009\u62e9\uff1f<\/h5>\n\n\n\n<ul><li>\u4e00\u822c\u4f7f\u7528\u5927\u5c0f\u8303\u56f4\u7b26\u5408\u7684\u6570\u636e\u7c7b\u578b<\/li><li>\u592a\u5927\u592a\u5c0f\u90fd\u4e0d\u597d<\/li><\/ul>\n\n\n\n<h5>5.\u4e3a\u4ec0\u4e48\u6ca1\u6709\u56fe\u7247\u683c\u5f0f\uff1f<\/h5>\n\n\n\n<ul><li>\u56fe\u7247\u4e00\u822c\u4e0d\u4f7f\u7528\u6570\u636e\u5e93\u5b58\u50a8<\/li><li>\u8981\u4e48\u5b58\u50a8\u56fe\u7247\u7684\u5f15\u7528\u5730\u5740\uff0c\u5373\u5b57\u7b26\u4e32\u7c7b\u578b<\/li><\/ul>\n\n\n\n<h5>6.\u90ae\u7bb1\u4f7f\u7528\u4ec0\u4e48\u7c7b\u578b\uff1f\u5b57\u7b26\u4e32\u7c7b\u578b<\/h5>\n","protected":false},"excerpt":{"rendered":"<p>\u5e38\u7528\u7684\u6570\u636e\u7c7b\u578b\u67093\u79cd\uff0c\u6570\u503c\uff0c\u65e5\u671f\u65f6\u95f4\uff0c\u5b57\u7b26\u4e32\u7c7b\u578b 1.\u6570\u503c\u7c7b\u578b \u7c7b\u578b \u5927\u5c0f \u8303\u56f4\uff08\u6709\u7b26\u53f7\uff09 \u8303\u56f4\uff08\u65e0\u7b26\u53f7\uff09 \u7528&hellip; <a href=\"https:\/\/www.52dixiaowo.com\/db\/post-31.html\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">mysql \u6570\u636e\u7c7b\u578b<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts\/31"}],"collection":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/comments?post=31"}],"version-history":[{"count":1,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts\/31\/revisions"}],"predecessor-version":[{"id":32,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts\/31\/revisions\/32"}],"wp:attachment":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/media?parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/categories?post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/tags?post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}