{"id":180,"date":"2026-01-31T16:10:11","date_gmt":"2026-01-31T08:10:11","guid":{"rendered":"http:\/\/47.100.165.17\/wordpress\/?p=180"},"modified":"2026-01-31T16:10:11","modified_gmt":"2026-01-31T08:10:11","slug":"%e3%80%90mysql%e3%80%91%e5%ad%97%e6%ae%b5%e7%b1%bb%e5%9e%8b%e4%b8%8e%e5%ad%97%e7%ac%a6%e9%9b%86%e8%af%a6%e8%a7%a3","status":"publish","type":"post","link":"https:\/\/yunyanglib.cn\/?p=180","title":{"rendered":"\u3010MySQL\u3011\u5b57\u6bb5\u7c7b\u578b\u4e0e\u5b57\u7b26\u96c6\u8be6\u89e3"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"m663T\">1.1 \u5e38\u89c1\u5b57\u7b26\u4e32\u7c7b\u578b\u53ca\u5e94\u7528\u573a\u666f<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"gEWlD\">1.1.1 \u6838\u5fc3\u5b57\u7b26\u4e32\u7c7b\u578b\u89e3\u6790<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>CHAR\u4e0eVARCHAR<\/strong>\uff1a\u5747\u7528\u4e8e\u5b58\u50a8\u5b57\u7b26\u4e32\uff0c\u4f46\u7279\u6027\u5dee\u5f02\u663e\u8457\u3002CHAR\u4e3a\u56fa\u5b9a\u957f\u5ea6\uff080-255\u5b57\u8282\uff09\uff0c\u5b58\u50a8\u65f6\u82e5\u5185\u5bb9\u957f\u5ea6\u4e0d\u8db3\uff0c\u4f1a\u81ea\u52a8\u7528\u7a7a\u683c\u586b\u5145\uff1bVARCHAR\u4e3a\u53ef\u53d8\u957f\u5ea6\uff080-65535\u5b57\u8282\uff09\uff0c\u4ec5\u5360\u7528\u5b9e\u9645\u5185\u5bb9\u6240\u9700\u7a7a\u95f4\uff0c\u66f4\u8282\u7701\u5b58\u50a8\u3002<\/li>\n\n\n\n<li><strong>TEXT\u4e0eBLOB<\/strong>\uff1a\u9002\u7528\u4e8e\u5927\u5185\u5bb9\u5b58\u50a8\u3002TEXT\u4e13\u4e3a\u957f\u6587\u672c\u8bbe\u8ba1\uff08\u5982\u6587\u7ae0\u3001\u65e5\u5fd7\uff09\uff1bBLOB\u5219\u7528\u4e8e\u4e8c\u8fdb\u5236\u6570\u636e\uff08\u5982\u56fe\u7247\u3001\u97f3\u9891\u6587\u4ef6\uff09\uff0c\u4e8c\u8005\u5747\u4e0d\u652f\u6301\u7d22\u5f15\u524d\u7f00\u3002<\/li>\n\n\n\n<li><strong>ENUM\u4e0eSET<\/strong>\uff1a\u679a\u4e3e\u7c7b\u7c7b\u578b\u3002ENUM\u5141\u8bb8\u4ece\u9884\u8bbe\u5217\u8868\u4e2d\u9009\u62e9<strong>\u552f\u4e00\u503c<\/strong>\uff08\u5982\u6027\u522b\uff1a\u7537\/\u5973\uff09\uff1bSET\u5141\u8bb8\u4ece\u9884\u8bbe\u5217\u8868\u4e2d\u9009\u62e9<strong>\u4e00\u4e2a\u6216\u591a\u4e2a\u503c<\/strong>\uff08\u5982\u5174\u8da3\uff1a\u8bfb\u4e66\/\u8fd0\u52a8\/\u97f3\u4e50\uff09\u3002<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"Ix9UJ\">1.1.2 \u5b9e\u8df5\u9a8c\u8bc1\uff1a\u7c7b\u578b\u7279\u6027\u5bf9\u6bd4<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"wrH7G\">\u5b9e\u9a8c1\uff1aCHAR\u4e0eVARCHAR\u7684\u5dee\u5f02<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u3f414cbb\">\u521b\u5efa\u6d4b\u8bd5\u8868\uff1a<\/p>\n\n\n\n<pre id=\"OTsxg\" class=\"wp-block-code\"><code>CREATE TABLE aaa(one CHAR(10), two VARCHAR(10));<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u957f\u5ea6\u9650\u5236\u9a8c\u8bc1<\/strong>\uff1a\u5199\u5165\u8d85\u8fc710\u4e2a\u5b57\u7b26\u7684\u6570\u636e\u65f6\uff0c\u4e8c\u8005\u5747\u4f1a\u89e6\u53d1\u9519\u8bef\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"FHYGC\" class=\"wp-block-code\"><code>INSERT INTO aaa(one) VALUES ('abcabcabcabc'); -- \u62a5\u9519\nINSERT INTO aaa(two) VALUES ('abcabcabcabc'); -- \u62a5\u9519<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u6b63\u5e38\u957f\u5ea6\u5199\u5165<\/strong>\uff1a10\u4e2a\u5b57\u7b26\u4ee5\u5185\u53ef\u6b63\u5e38\u5b58\u50a8\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"Yni22\" class=\"wp-block-code\"><code>INSERT INTO aaa(one) VALUES ('aaa');\nINSERT INTO aaa(two) VALUES ('aaa');<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u7a7a\u683c\u5904\u7406\u5dee\u5f02<\/strong>\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"IrJA6\" class=\"wp-block-code\"><code>INSERT INTO aaa VALUES ('a  ', 'a  '); -- \u5747\u5199\u5165\u5e262\u4e2a\u5c3e\u7a7a\u683c\u7684\u5b57\u7b26\u4e32\nSELECT CONCAT(one, '|'), CONCAT(two, '|') FROM aaa; -- \u67e5\u770b\u7ed3\u679c<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ua0730d59\">\u7ed3\u679c\u663e\u793a\uff1aCHAR\u4f1a\u81ea\u52a8\u53bb\u9664\u5c3e\u90e8\u7a7a\u683c\uff0cVARCHAR\u5219\u4fdd\u7559\u5c3e\u90e8\u7a7a\u683c\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"CjgJx\">\u5b9e\u9a8c2\uff1aENUM\u7c7b\u578b\u7684\u9650\u5236\u4e0e\u7d22\u5f15\u7279\u6027<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ude79567f\">\u521b\u5efa\u8868\u5e76\u63d2\u5165\u6570\u636e\uff1a<\/p>\n\n\n\n<pre id=\"M2mbT\" class=\"wp-block-code\"><code>CREATE TABLE bbb(name VARCHAR(10), gender ENUM('\u7537', '\u5973'));\nINSERT INTO bbb VALUES ('a', '\u7537'), ('b', '\u5973');<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u975e\u6cd5\u503c\u63d2\u5165\u9650\u5236<\/strong>\uff1a\u5199\u5165\u679a\u4e3e\u5217\u8868\u5916\u7684\u503c\u4f1a\u62a5\u9519\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"i8yvP\" class=\"wp-block-code\"><code>INSERT INTO bbb VALUES ('c', '\u5176\u4ed6'); -- \u62a5\u9519\uff08'\u5176\u4ed6'\u4e0d\u5728\u9884\u8bbe\u5217\u8868\u4e2d\uff09<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u7d22\u5f15\u7279\u6027<\/strong>\uff1a\u6bcf\u4e2a\u679a\u4e3e\u503c\u5bf9\u5e94\u552f\u4e00\u7d22\u5f15\uff08\u4ece1\u5f00\u59cb\uff09\uff0c\u53ef\u901a\u8fc7\u7d22\u5f15\u67e5\u8be2\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"rD04y\" class=\"wp-block-code\"><code>SELECT * FROM bbb WHERE gender = 1; -- \u7b49\u4ef7\u4e8e gender = '\u7537'\nSELECT * FROM bbb WHERE gender = 2; -- \u7b49\u4ef7\u4e8e gender = '\u5973'<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Fxt7M\">\u5b9e\u9a8c3\uff1aSET\u7c7b\u578b\u7684\u591a\u503c\u5b58\u50a8<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"uf3b5fe68\">\u521b\u5efa\u8868\u5e76\u63d2\u5165\u6570\u636e\uff1a<\/p>\n\n\n\n<pre id=\"hTFlr\" class=\"wp-block-code\"><code>CREATE TABLE ccc(one SET('a', 'b', 'c', 'd'));\nINSERT INTO ccc VALUES ('a,b,c'), ('a,a'), ('b,d,b'); -- \u91cd\u590d\u503c\u4f1a\u81ea\u52a8\u53bb\u91cd<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u975e\u6cd5\u503c\u9650\u5236<\/strong>\uff1a\u5199\u5165\u5217\u8868\u5916\u7684\u503c\u4f1a\u62a5\u9519\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"zUFnn\" class=\"wp-block-code\"><code>INSERT INTO ccc VALUES ('a,b,e'); -- \u62a5\u9519\uff08'e'\u4e0d\u5728\u9884\u8bbe\u5217\u8868\u4e2d\uff09<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"LRggU\">1.1.3 \u7c7b\u578b\u9009\u62e9\u6307\u5357<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"uaa6106eb\">\u9009\u62e9\u5b57\u7b26\u4e32\u7c7b\u578b\u9700\u7ed3\u5408<strong>\u957f\u5ea6\u7a33\u5b9a\u6027\u3001\u5b58\u50a8\u6548\u7387\u3001\u67e5\u8be2\u9700\u6c42<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u56fa\u5b9a\u957f\u5ea6\u4e14\u77ed\u5185\u5bb9\uff08\u5982\u624b\u673a\u53f7\u3001\u8eab\u4efd\u8bc1\u53f7\uff09\uff1a\u4f18\u5148\u7528CHAR\uff08\u67e5\u8be2\u66f4\u5feb\uff09\u3002<\/li>\n\n\n\n<li>\u957f\u5ea6\u4e0d\u56fa\u5b9a\u4e14\u53ef\u80fd\u8f83\u957f\uff08\u5982\u7528\u6237\u540d\u3001\u5730\u5740\uff09\uff1a\u4f18\u5148\u7528VARCHAR\uff08\u8282\u7701\u7a7a\u95f4\uff09\u3002<\/li>\n\n\n\n<li>\u8d85\u957f\u7bc7\u6587\u672c\uff08\u5982\u6587\u7ae0\u5185\u5bb9\uff09\uff1a\u7528TEXT\uff1b\u4e8c\u8fdb\u5236\u6570\u636e\uff1a\u7528BLOB\u3002<\/li>\n\n\n\n<li>\u6709\u9650\u53ef\u9009\u503c\u573a\u666f\uff1a\u5355\u9009\u7528ENUM\uff0c\u591a\u9009\u7528SET\uff08\u9700\u6ce8\u610f\u4e8c\u8005\u5747\u4e0d\u9002\u5408\u9ad8\u9891\u53d8\u66f4\u7684\u9009\u9879\u5217\u8868\uff09\u3002<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"cyaHu\">1.2 \u6574\u6570\u7c7b\u578b\u6df1\u5ea6\u89e3\u6790\u53ca\u5e94\u7528\u573a\u666f<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"HzF7N\">1.2.1 \u6838\u5fc3\u6574\u6570\u7c7b\u578b\u7279\u6027<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u29e46e24\">\u6574\u6570\u7c7b\u578b\u7684\u9009\u62e9\u9700\u6743\u8861<strong>\u53d6\u503c\u8303\u56f4<\/strong>\u4e0e<strong>\u5b58\u50a8\u5f00\u9500<\/strong>\uff0c\u4ee5\u4e0b\u4e3a\u5e38\u89c1\u7c7b\u578b\u5bf9\u6bd4\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u7c7b\u578b<\/td><td>\u5b57\u8282\u6570<\/td><td>\u6709\u7b26\u53f7\u53d6\u503c\u8303\u56f4<\/td><td>\u65e0\u7b26\u53f7\u53d6\u503c\u8303\u56f4<\/td><td>\u5178\u578b\u5e94\u7528\u573a\u666f<\/td><\/tr><tr><td>TINYINT<\/td><td>1<\/td><td>-128 ~ 127<\/td><td>0 ~ 255<\/td><td>\u72b6\u6001\u7801\uff080-1-2\uff09\u3001\u6027\u522b\u6807\u8bc6<\/td><\/tr><tr><td>SMALLINT<\/td><td>2<\/td><td>-32768 ~ 32767<\/td><td>0 ~ 65535<\/td><td>\u5e74\u9f84\u3001\u5e74\u4efd<\/td><\/tr><tr><td>MEDIUMINT<\/td><td>3<\/td><td>-8388608 ~ 8388607<\/td><td>0 ~ 16777215<\/td><td>\u4e2d\u578b\u8ba1\u6570\u5668<\/td><\/tr><tr><td>INT<\/td><td>4<\/td><td>-2147483648 ~ 2147483647<\/td><td>0 ~ 4294967295<\/td><td>\u4e3b\u952eID\u3001\u7528\u6237\u6570<\/td><\/tr><tr><td>BIGINT<\/td><td>8<\/td><td>-9e18 ~ 9e18<\/td><td>0 ~ 1.8e19<\/td><td>\u91d1\u878d\u6570\u636e\u3001\u9ad8\u7cbe\u5ea6\u8ba1\u6570\u5668<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"TatDr\">1.2.2 \u5b9e\u8df5\u9a8c\u8bc1\uff1a\u6574\u6570\u7c7b\u578b\u7684\u8303\u56f4\u9650\u5236<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"G9lur\">\u5b9e\u9a8c\uff1aINT\u7c7b\u578b\u7684\u6709\u7b26\u53f7\u4e0e\u65e0\u7b26\u53f7\u5dee\u5f02<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u6709\u7b26\u53f7INT<\/strong>\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"wfQzl\" class=\"wp-block-code\"><code>CREATE TABLE int_test(id INT);\nINSERT INTO int_test VALUES (2147483647); -- \u6b63\u5e38\u63d2\u5165\uff08\u6700\u5927\u503c\uff09\nINSERT INTO int_test VALUES (2147483648); -- \u62a5\u9519\uff08\u8d85\u51fa\u8303\u56f4\uff09<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u65e0\u7b26\u53f7INT<\/strong>\uff08\u9700\u663e\u5f0f\u58f0\u660e\uff09\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"C7h0W\" class=\"wp-block-code\"><code>CREATE TABLE int_test_unsigned(id INT UNSIGNED);\nINSERT INTO int_test_unsigned VALUES (2147483648); -- \u6b63\u5e38\uff08\u65e0\u7b26\u53f7\u6700\u5c0f\u503c\uff09\nINSERT INTO int_test_unsigned VALUES (4294967295); -- \u6b63\u5e38\uff08\u65e0\u7b26\u53f7\u6700\u5927\u503c\uff09\nINSERT INTO int_test_unsigned VALUES (4294967296); -- \u62a5\u9519\uff08\u8d85\u51fa\u8303\u56f4\uff09<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"qAlPB\">1.2.3 \u7c7b\u578b\u9009\u62e9\u539f\u5219<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u9075\u5faa\u201c\u6700\u5c0f\u591f\u7528\u201d\u539f\u5219\uff1a\u5982\u5e74\u9f84\u7528TINYINT UNSIGNED\uff080-255\u5b8c\u5168\u8986\u76d6\u4eba\u7c7b\u5e74\u9f84\u8303\u56f4\uff09\uff0c\u907f\u514d\u7528INT\u6d6a\u8d39\u7a7a\u95f4\u3002<\/li>\n\n\n\n<li>\u9ad8\u9891\u67e5\u8be2\u5b57\u6bb5\u4f18\u5148\u9009\u5c0f\u7c7b\u578b\uff1a\u51cf\u5c11IO\u5f00\u9500\uff0c\u63d0\u5347\u67e5\u8be2\u6548\u7387\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\u7b26\u53f7\u9700\u6c42\uff1a\u5982\u8ba1\u6570\u5668\u3001ID\u7b49\u975e\u8d1f\u6570\u636e\uff0c\u7528UNSIGNED\u6269\u5c55\u53d6\u503c\u8303\u56f4\uff08\u5982INT UNSIGNED\u6bd4INT\u591a\u4e00\u500d\u6b63\u6570\u503c\u7a7a\u95f4\uff09\u3002<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"IiAmU\">1.3 \u6d6e\u70b9\u6570\u4e0e\u5b9a\u70b9\u6570\uff1a\u5dee\u5f02\u53ca\u573a\u666f\u9009\u62e9<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"WsPe7\">1.3.1 \u6838\u5fc3\u7c7b\u578b\u89e3\u6790<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>FLOAT<\/strong>\uff1a\u5355\u7cbe\u5ea6\u6d6e\u70b9\u6570\uff0832\u4f4d\uff09\uff0c\u7cbe\u5ea6\u7ea67\u4f4d\u5341\u8fdb\u5236\u6570\uff0c\u9002\u5408\u5bf9\u7cbe\u5ea6\u8981\u6c42\u4f4e\u4f46\u6027\u80fd\u654f\u611f\u7684\u573a\u666f\uff08\u5982\u6e38\u620f\u6570\u503c\uff09\uff0c\u5b58\u5728\u820d\u5165\u8bef\u5dee\u3002<\/li>\n\n\n\n<li><strong>DOUBLE<\/strong>\uff1a\u53cc\u7cbe\u5ea6\u6d6e\u70b9\u6570\uff0864\u4f4d\uff09\uff0c\u7cbe\u5ea6\u7ea615\u4f4d\u5341\u8fdb\u5236\u6570\uff0c\u9002\u7528\u4e8e\u79d1\u5b66\u8ba1\u7b97\u7b49\u4e2d\u7b49\u7cbe\u5ea6\u573a\u666f\uff0c\u4ecd\u53ef\u80fd\u6709\u8bef\u5dee\u3002<\/li>\n\n\n\n<li><strong>DECIMAL<\/strong>\uff1a\u5b9a\u70b9\u6570\uff0c\u901a\u8fc7<code>DECIMAL(M,D)<\/code>\u5b9a\u4e49\uff08M\u4e3a\u603b\u4f4d\u6570\uff0cD\u4e3a\u5c0f\u6570\u4f4d\u6570\uff09\uff0c\u65e0\u820d\u5165\u8bef\u5dee\uff0c\u9002\u5408\u9ad8\u7cbe\u5ea6\u573a\u666f\uff08\u5982\u91d1\u878d\u4ea4\u6613\uff09\uff0c\u4f46\u8ba1\u7b97\u6027\u80fd\u7565\u4f4e\u3002<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"l3uus\">1.3.2 \u5b9e\u8df5\u9a8c\u8bc1\uff1a\u7cbe\u5ea6\u4e0e\u8303\u56f4\u5dee\u5f02<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"uZcQY\">\u5b9e\u9a8c1\uff1aDECIMAL\u7684\u8303\u56f4\u9650\u5236<\/h4>\n\n\n\n<pre id=\"dMjKF\" class=\"wp-block-code\"><code>CREATE TABLE decimal_test(aaa DECIMAL(5,2)); -- \u603b\u957f\u5ea65\u4f4d\uff0c\u5c0f\u65702\u4f4d\uff08\u8303\u56f4\uff1a-999.99 ~ 999.99\uff09\nINSERT INTO decimal_test VALUES (-999.99), (999.99); -- \u6b63\u5e38\u63d2\u5165\nINSERT INTO decimal_test VALUES (-1000.99); -- \u62a5\u9519\uff08\u8d85\u51fa\u6574\u6570\u90e8\u5206\u8303\u56f4\uff09\nINSERT INTO decimal_test VALUES (2.343); -- \u81ea\u52a8\u56db\u820d\u4e94\u5165\u4e3a2.34\ncreate table decimal_test_1(a decimal); -- \u5f53DECIMAL\u7c7b\u578b\u4e0d\u6307\u5b9a\u7cbe\u5ea6\u548c\u523b\u5ea6\uff0c\u9ed8\u8ba4\u5c31\u662fdecimal(10,0)\nshow create table decimal_test_1;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"A8K3Z\">\u5b9e\u9a8c2\uff1a\u6d6e\u70b9\u6570\u4e0e\u5b9a\u70b9\u6570\u7684\u7cbe\u5ea6\u5dee\u5f02<\/h4>\n\n\n\n<pre id=\"ghk8I\" class=\"wp-block-code\"><code>CREATE TABLE float_decimal_test(a FLOAT, b DECIMAL(8,4)); -- \u5bf9\u6bd4\u4e24\u8005\u7cbe\u5ea6\nINSERT INTO float_decimal_test VALUES (7777.7777, 7777.7777), (66.6666, 66.6666);\nSELECT * FROM float_decimal_test;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ub9331b47\">\u7ed3\u679c\u663e\u793a\uff1aFLOAT\u4f1a\u56e0\u7cbe\u5ea6\u9650\u5236\u51fa\u73b0\u8fd1\u4f3c\u503c\uff0cDECIMAL\u5219\u5b8c\u5168\u7cbe\u786e\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"cUFpW\">1.3.3 \u7c7b\u578b\u9009\u62e9\u6307\u5357<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u91d1\u878d\/\u652f\u4ed8\u573a\u666f\uff1a\u5f3a\u5236\u7528DECIMAL\uff08\u5982<code>DECIMAL(10,2)<\/code>\u5b58\u50a8\u91d1\u989d\uff09\uff0c\u907f\u514d\u7cbe\u5ea6\u635f\u5931\u3002<\/li>\n\n\n\n<li>\u79d1\u5b66\u8ba1\u7b97\/\u6e38\u620f\uff1a\u7528DOUBLE\uff08\u5e73\u8861\u7cbe\u5ea6\u4e0e\u6027\u80fd\uff09\u3002<\/li>\n\n\n\n<li>\u4f4e\u7cbe\u5ea6\u573a\u666f\uff08\u5982\u6e29\u5ea6\u3001\u8bc4\u5206\uff09\uff1a\u7528FLOAT\uff08\u8282\u7701\u7a7a\u95f4\uff09\u3002<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"g50YL\">1.4 \u65f6\u95f4\u7c7b\u578b\u8be6\u89e3\u53ca\u5b9e\u8df5\u5e94\u7528<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"OXAuX\">1.4.1 \u6838\u5fc3\u65f6\u95f4\u7c7b\u578b\u7279\u6027<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u7c7b\u578b<\/td><td>\u5b58\u50a8\u5185\u5bb9<\/td><td>\u53d6\u503c\u8303\u56f4<\/td><td>\u6838\u5fc3\u7279\u6027<\/td><td>\u5178\u578b\u573a\u666f<\/td><\/tr><tr><td>DATE<\/td><td>\u5e74\u6708\u65e5<\/td><td>1000-01-01 ~ 9999-12-31<\/td><td>\u4ec5\u65e5\u671f\uff0c\u65e0\u65f6\u95f4<\/td><td>\u751f\u65e5\u3001\u6ce8\u518c\u65e5\u671f<\/td><\/tr><tr><td>TIME<\/td><td>\u65f6\u5206\u79d2<\/td><td>-838:59:59 ~ 838:59:59<\/td><td>\u53ef\u8868\u793a\u8de8\u5929\u65f6\u95f4\uff08\u598230\u5c0f\u65f6\uff09<\/td><td>\u65f6\u957f\u3001\u6bcf\u65e5\u6253\u5361\u65f6\u95f4<\/td><\/tr><tr><td>YEAR<\/td><td>\u5e74\u4efd<\/td><td>1901 ~ 2155<\/td><td>\u4ec5\u5b58\u50a8\u5e74\u4efd\uff0c\u53601\u5b57\u8282<\/td><td>\u6bd5\u4e1a\u5e74\u4efd\u3001\u4ea7\u54c1\u5e74\u4efd<\/td><\/tr><tr><td>DATETIME<\/td><td>\u5e74\u6708\u65e5\u65f6\u5206\u79d2<\/td><td>1000-01-01 00:00:00 ~ 9999-12-31 23:59:59<\/td><td>\u65e0\u65f6\u533a\uff0c\u5b58\u50a8\u7edd\u5bf9\u65f6\u95f4<\/td><td>\u8ba2\u5355\u521b\u5efa\u65f6\u95f4<\/td><\/tr><tr><td>TIMESTAMP<\/td><td>\u5e74\u6708\u65e5\u65f6\u5206\u79d2<\/td><td>1970-01-01 00:00:01 ~ 2038-01-19 03:14:07<\/td><td>\u542b\u65f6\u533a\uff0c\u4f1a\u968f\u670d\u52a1\u5668\u65f6\u533a\u81ea\u52a8\u8c03\u6574<\/td><td>\u8de8\u65f6\u533a\u7cfb\u7edf\u7684\u65f6\u95f4\u8bb0\u5f55<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"ysOKx\">1.4.2 \u5b9e\u8df5\u9a8c\u8bc1\uff1a\u65f6\u95f4\u7c7b\u578b\u7684\u7279\u6027<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"zIWZ8\">\u5b9e\u9a8c1\uff1aTIME\u7684\u8303\u56f4\u9650\u5236<\/h4>\n\n\n\n<pre id=\"z7RO1\" class=\"wp-block-code\"><code>CREATE TABLE time_test(a TIME);\nINSERT INTO time_test VALUES ('20:08:08'); -- \u6b63\u5e38\u63d2\u5165\nINSERT INTO time_test VALUES ('839:08:08'); -- \u62a5\u9519\uff08\u8d85\u51fa838:59:59\u4e0a\u9650\uff09\nINSERT INTO time_test VALUES ('838:08:08'); -- \u6b63\u5e38\u63d2\u5165\uff08\u8303\u56f4\u5185\uff09<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Isps1\">\u5b9e\u9a8c2\uff1aTIMESTAMP\u7684\u65f6\u533a\u654f\u611f\u6027<\/h4>\n\n\n\n<pre id=\"U8Cbl\" class=\"wp-block-code\"><code>CREATE TABLE datetime_timestamp_test(a DATETIME, b TIMESTAMP);\nINSERT INTO datetime_timestamp_test VALUES (NOW(), NOW()); -- \u63d2\u5165\u5f53\u524d\u65f6\u95f4\nSELECT * FROM datetime_timestamp_test; -- \u521d\u59cb\u67e5\u8be2\uff08\u9ed8\u8ba4\u65f6\u533a\uff09\n\nSET time_zone = '+05:00'; -- \u5207\u6362\u65f6\u533a\nSELECT * FROM datetime_timestamp_test; -- \u7ed3\u679c\u663e\u793a\uff1aTIMESTAMP\u503c\u968f\u65f6\u533a\u53d8\u5316\uff0cDATETIME\u4e0d\u53d8<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Sc0HQ\">\u5b9e\u9a8c3\uff1a\u81ea\u52a8\u7ef4\u62a4\u521b\u5efa\/\u66f4\u65b0\u65f6\u95f4<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u8874b03e\">\u901a\u8fc7<code>DEFAULT<\/code>\u4e0e<code>ON UPDATE<\/code>\u5b9e\u73b0\u65f6\u95f4\u81ea\u52a8\u8bb0\u5f55\uff1a<\/p>\n\n\n\n<pre id=\"FxhvM\" class=\"wp-block-code\"><code>CREATE TABLE default_time_test(\n  id INT PRIMARY KEY AUTO_INCREMENT COMMENT '\u4e3b\u952e',\n  name VARCHAR(10),\n  create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '\u521b\u5efa\u65f6\u95f4\uff08\u63d2\u5165\u65f6\u81ea\u52a8\u8bb0\u5f55\uff09',\n  update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '\u66f4\u65b0\u65f6\u95f4\uff08\u4fee\u6539\u65f6\u81ea\u52a8\u66f4\u65b0\uff09'\n) ENGINE=InnoDB CHARSET=utf8mb4;\n\n-- \u63d2\u5165\u6570\u636e\uff08\u81ea\u52a8\u8bb0\u5f55create_time\uff09\nINSERT INTO default_time_test(name) VALUES ('aa');\n-- \u66f4\u65b0\u6570\u636e\uff08\u81ea\u52a8\u66f4\u65b0update_time\uff09\nUPDATE default_time_test SET name = 'bb' WHERE id = 1;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"iPCaW\">1.4.3 \u7c7b\u578b\u9009\u62e9\u539f\u5219<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4ec5\u9700\u65e5\u671f\uff1a\u7528DATE\uff08\u5982\u751f\u65e5\uff09\uff1b\u4ec5\u9700\u65f6\u95f4\uff1a\u7528TIME\uff08\u5982\u6bcf\u65e5\u6253\u5361\uff09\u3002<\/li>\n\n\n\n<li>\u957f\u671f\u65f6\u95f4\u8bb0\u5f55\uff08\u8d85\u8fc72038\u5e74\uff09\uff1a\u7528DATETIME\uff08\u65e02038\u5e74\u9650\u5236\uff09\u3002<\/li>\n\n\n\n<li>\u8de8\u65f6\u533a\u7cfb\u7edf\uff1a\u7528TIMESTAMP\uff08\u81ea\u52a8\u9002\u914d\u65f6\u533a\uff09\u3002<\/li>\n\n\n\n<li>\u9700\u81ea\u52a8\u7ef4\u62a4\u521b\u5efa\/\u66f4\u65b0\u65f6\u95f4\uff1a\u4f18\u5148\u7528TIMESTAMP\uff08\u8bed\u6cd5\u7b80\u6d01\uff09\u3002<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"MO5Z9\">1.5 \u5b57\u7b26\u96c6\u5bf9MySQL\u7684\u5f71\u54cd<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"n3roS\">1.5.1 \u6838\u5fc3\u6982\u5ff5\uff1a\u5b57\u7b26\u96c6\u4e0e\u6392\u5e8f\u89c4\u5219<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u5b57\u7b26\u96c6<\/strong>\uff1a\u5b9a\u4e49\u5b57\u7b26\u7684\u7f16\u7801\u65b9\u5f0f\uff08\u5982UTF8MB4\u652f\u6301\u4e2d\u6587\u3001emoji\uff09\u3002<\/li>\n\n\n\n<li><strong>\u6392\u5e8f\u89c4\u5219<\/strong>\uff1a\u5b9a\u4e49\u5b57\u7b26\u7684\u6bd4\u8f83\u89c4\u5219\uff08\u5982\u662f\u5426\u533a\u5206\u5927\u5c0f\u5199\u3001\u91cd\u97f3\uff09\uff0c\u901a\u5e38\u4f9d\u9644\u4e8e\u5b57\u7b26\u96c6\uff08\u5982<code>utf8mb4_general_ci<\/code>\u4e0d\u533a\u5206\u5927\u5c0f\u5199\uff09\u3002<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"H5A1p\">1.5.2 \u5e38\u89c1\u5b57\u7b26\u96c6\u5bf9\u6bd4<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u5b57\u7b26\u96c6<\/td><td>\u957f\u5ea6<\/td><td>\u8bf4\u660e<\/td><\/tr><tr><td>GBK<\/td><td>2<\/td><td>\u652f\u6301\u4e2d\u6587\uff0c\u4f46\u662f\u4e0d\u662f\u56fd\u9645\u901a\u7528\u5b57\u7b26\u96c6<\/td><\/tr><tr><td>latin1<\/td><td>1<\/td><td>MySQL8.0\u4e4b\u524d\u9ed8\u8ba4\u7684\u5b57\u7b26\u96c6<\/td><\/tr><tr><td>utf8<\/td><td>3<\/td><td>\u652f\u6301\u4e2d\u82f1\u6587\u6df7\u5408\u573a\u666f\uff0c\u662f\u56fd\u9645\u901a\u7528\u5b57\u7b26\u96c6<\/td><\/tr><tr><td>utf8mb4<\/td><td>4<\/td><td>\u5b8c\u5168\u517c\u5bb9utf8\uff0c\u7528\u56db\u4e2a\u5b57\u8282\u5b58\u50a8\u66f4\u591a\u7684\u5b57\u7b26\uff0cMySQL8.0\u9ed8\u8ba4\u7684\u5b57\u7b26\u96c6<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"BysFp\">1.5.3 \u6392\u5e8f\u89c4\u5219\u540e\u7f00<\/h3>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u540e\u7f00<\/td><td>\u63cf\u8ff0<\/td><\/tr><tr><td>_ai<\/td><td>\u4e0d\u533a\u5206\u91cd\u97f3<\/td><\/tr><tr><td>_as<\/td><td>\u533a\u5206\u91cd\u97f3<\/td><\/tr><tr><td>_ci<\/td><td>\u4e0d\u533a\u5206\u5927\u5c0f\u5199<\/td><\/tr><tr><td>_cs<\/td><td>\u533a\u5206\u5927\u5c0f\u5199<\/td><\/tr><tr><td>_bin<\/td><td>\u4e8c\u8fdb\u5236<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"Y102V\">1.5.4 \u5b57\u7b26\u96c6\u7684\u5173\u952e\u5f71\u54cd<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u4e71\u7801\u98ce\u9669<\/strong>\uff1a\u82e5\u5ba2\u6237\u7aef\u4e0e\u670d\u52a1\u7aef\u5b57\u7b26\u96c6\u4e0d\u4e00\u81f4\uff0c\u4f1a\u5bfc\u81f4\u4e2d\u6587\/\u7279\u6b8a\u5b57\u7b26\u4e71\u7801\u3002<\/li>\n\n\n\n<li><strong>\u7d22\u5f15\u5931\u6548<\/strong>\uff1a\u5173\u8054\u67e5\u8be2\u4e2d\uff0c\u82e5\u5173\u8054\u5b57\u6bb5\u5b57\u7b26\u96c6\u4e0d\u540c\uff0c\u7d22\u5f15\u65e0\u6cd5\u751f\u6548\uff0c\u5bfc\u81f4\u5168\u8868\u626b\u63cf\u3002<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"qajET\">1.5.5 \u5b9e\u8df5\u9a8c\u8bc1\uff1a\u4e71\u7801\u95ee\u9898\u590d\u73b0<\/h3>\n\n\n\n<pre id=\"k1h5M\" class=\"wp-block-code\"><code>-- 1. \u670d\u52a1\u7aef\u8bbe\u4e3aUTF8MB4\uff0c\u521b\u5efa\u8868\nSET NAMES utf8mb4;\nCREATE TABLE charset_test1(aaa VARCHAR(10)) CHARSET = utf8mb4;\n\n-- 2. \u5ba2\u6237\u7aef\u5207\u6362\u4e3aGBK\uff0c\u63d2\u5165\u4e2d\u6587\nSET NAMES gbk;\nINSERT INTO charset_test1(aaa) VALUES ('\u4e2d\u6587'); -- \u76f4\u63a5\u62a5\u9519\uff08\u4e25\u683c\u6a21\u5f0f\u4e0b\uff09\n\n-- 3. \u4e34\u65f6\u5173\u95ed\u4e25\u683c\u6a21\u5f0f\u540e\u63d2\u5165\nselect @@sql_mode; -- \u67e5\u770bsql_mode\nSET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; -- \u4fee\u6539sql_mode\uff0c\u53bb\u6389\u5176\u4e2d\u7684STRICT_TRANS_TABLES\nINSERT INTO charset_test1(aaa) VALUES ('\u4e2d\u6587'); -- \u63d0\u793a\u8b66\u544a\uff0c\u4f46\u63d2\u5165\u6210\u529f\nshow warnings; -- \u67e5\u770bwarning\u5185\u5bb9\uff0c\u63d0\u793a\u6211\u4eec\u5199\u5165\u7684\u6570\u636e\u4e0d\u5bf9\n\n-- 4. \u67e5\u8be2\u7ed3\u679c\uff08\u4e71\u7801\uff09\nSELECT * FROM charset_test1; -- \u663e\u793a\u4e71\u7801\uff08\u7f16\u7801\u4e0d\u5339\u914d\u5bfc\u81f4\uff09<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Pz5Qj\">1.6 MySQL\u5b57\u7b26\u96c6\u7684\u914d\u7f6e\u65b9\u6cd5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"GBoaN\">1.6.1 \u67e5\u770b\u5b57\u7b26\u96c6\u4fe1\u606f<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u67e5\u770b\u6240\u6709\u53ef\u7528\u5b57\u7b26\u96c6\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"T7dmm\" class=\"wp-block-code\"><code>SHOW CHARACTER SET;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u67e5\u770b\u6307\u5b9a\u5b57\u7b26\u96c6\u7684\u6392\u5e8f\u89c4\u5219\uff08\u4ee5UTF8MB4\u4e3a\u4f8b\uff09\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"YF2qL\" class=\"wp-block-code\"><code>SHOW COLLATION WHERE Charset = 'utf8mb4';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"N35cP\">1.6.2 \u591a\u7ea7\u522b\u5b57\u7b26\u96c6\u914d\u7f6e<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"wJYmx\">1. \u670d\u52a1\u5668\u7ea7\uff08\u5168\u5c40\u9ed8\u8ba4\uff09<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u67e5\u770b\u5f53\u524d\u914d\u7f6e\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"uTPVx\" class=\"wp-block-code\"><code>SHOW VARIABLES LIKE 'character_set_server'; -- \u5b57\u7b26\u96c6\nSHOW VARIABLES LIKE 'collation_server'; -- \u6392\u5e8f\u89c4\u5219<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u914d\u7f6e\u65b9\u5f0f\uff1a<\/li>\n\n\n\n<li>\u542f\u52a8\u53c2\u6570\uff1a<code>mysqld --character-set-server=utf8mb4 --collation-server=utf8mb4_0900_ai_ci<\/code><\/li>\n\n\n\n<li>\u914d\u7f6e\u6587\u4ef6\uff08my.conf\uff09\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"AGIkr\" class=\"wp-block-code\"><code># \u6253\u5f00\u5e76\u7f16\u8f91\u914d\u7f6e\u6587\u4ef6\nvim \/data\/mysql\/conf\/my.conf\n&#91;mysqld]\ncharacter_set_server = utf8mb4\ncollation_server = utf8mb4_0900_ai_ci<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u52a8\u6001\u4fee\u6539\uff08\u9700\u6743\u9650\uff09\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"F7fPu\" class=\"wp-block-code\"><code>SET GLOBAL character_set_server = utf8mb4;\nSET GLOBAL collation_server = utf8mb4_0900_ai_ci;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"F6m5s\">2. \u6570\u636e\u5e93\u7ea7\uff08\u8986\u76d6\u670d\u52a1\u5668\u7ea7\uff09<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u43b05b6e\">\u521b\u5efa\u6570\u636e\u5e93\u65f6\u6307\u5b9a\uff1a<\/p>\n\n\n\n<pre id=\"QAuSu\" class=\"wp-block-code\"><code>CREATE DATABASE latin_test CHARACTER SET latin1 COLLATE latin1_swedish_ci;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u38471725\">\u67e5\u770b\u6570\u636e\u5e93\u5b57\u7b26\u96c6\uff1a<\/p>\n\n\n\n<pre id=\"S7bND\" class=\"wp-block-code\"><code># \u65b9\u5f0f\u4e00\nSELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME \nFROM INFORMATION_SCHEMA.SCHEMATA \nWHERE SCHEMA_NAME = 'latin_test';\n\n# \u65b9\u5f0f\u4e8c\nuse latin_test;\nSELECT @@character_set_database, @@collation_database;\n\n# \u65b9\u5f0f\u4e09\nshow create database latin_test;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"GEXy8\">3. \u8868\u7ea7\uff08\u8986\u76d6\u6570\u636e\u5e93\u7ea7\uff09<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"uf5632a7f\">\u521b\u5efa\u8868\u65f6\u6307\u5b9a\uff1a<\/p>\n\n\n\n<pre id=\"woTsT\" class=\"wp-block-code\"><code>CREATE TABLE test1(a VARCHAR(10)) \nENGINE=InnoDB \nCHARSET=utf8mb4 \nCOLLATE=utf8mb4_0900_ai_ci;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u0ded2d96\">\u67e5\u770b\u5f53\u524d\u8868\u7684\u5b57\u7b26\u96c6\uff1a<\/p>\n\n\n\n<pre id=\"WkVmw\" class=\"wp-block-code\"><code>show create table test1;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u39aa3f94\">\u4fee\u6539\u8868\u5b57\u7b26\u96c6\uff1a<\/p>\n\n\n\n<pre id=\"sG1Kt\" class=\"wp-block-code\"><code>ALTER TABLE test1 CHARSET = latin1 COLLATE = latin1_danish_ci;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"wDJ28\">4. \u5b57\u6bb5\u7ea7\uff08\u8986\u76d6\u8868\u7ea7\uff09<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"uee4a629d\">\u521b\u5efa\u8868\u65f6\u6307\u5b9a\u5b57\u6bb5\u5b57\u7b26\u96c6\uff1a<\/p>\n\n\n\n<pre id=\"HA2dy\" class=\"wp-block-code\"><code>CREATE TABLE column_character_test(\n  name VARCHAR(10) CHARSET latin1 COLLATE latin1_danish_ci\n);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ud8a75501\">\u67e5\u770b\u5b57\u6bb5\u7684\u5b57\u7b26\u96c6\uff1a<\/p>\n\n\n\n<pre id=\"inde0\" class=\"wp-block-code\"><code>show create table column_character_test;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"uc4ea6cb3\">\u4fee\u6539\u5b57\u6bb5\u5b57\u7b26\u96c6\uff1a<\/p>\n\n\n\n<pre id=\"DN90Y\" class=\"wp-block-code\"><code>ALTER TABLE column_character_test \nMODIFY name VARCHAR(10) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"gxOQH\">1.7 \u5b57\u7b26\u96c6\u4f7f\u7528\u5efa\u8bae<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u663e\u5f0f\u58f0\u660e<\/strong>\uff1a\u5efa\u5e93\u3001\u5efa\u8868\u65f6\u5fc5\u987b\u660e\u786e\u6307\u5b9a\u5b57\u7b26\u96c6\uff08\u5982<code>CHARSET=utf8mb4<\/code>\uff09\uff0c\u907f\u514d\u4f9d\u8d56\u9ed8\u8ba4\u914d\u7f6e\u5bfc\u81f4\u8fc1\u79fb\u4e71\u7801\u3002<\/li>\n\n\n\n<li><strong>\u5168\u5c40\u7edf\u4e00<\/strong>\uff1a\u786e\u4fdd\u5ba2\u6237\u7aef\uff08\u5982Java\/Python\u4ee3\u7801\uff09\u3001\u670d\u52a1\u7aef\u3001\u5bfc\u5165\u6587\u4ef6\u7684\u5b57\u7b26\u96c6\u4e00\u81f4\uff08\u4f18\u5148UTF8MB4\uff09\u3002<\/li>\n\n\n\n<li><strong>\u4f18\u5148UTF8MB4<\/strong>\uff1a\u65e0\u7279\u6b8a\u9650\u5236\u65f6\uff0c\u9ed8\u8ba4\u7528UTF8MB4\uff08\u652f\u6301\u6240\u6709\u5b57\u7b26\uff0c\u517c\u5bb9\u672a\u6765\u9700\u6c42\uff09\u3002<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Qlo9F\">1.8 \u6848\u4f8b\uff1a\u5546\u54c1\u8868\u8bbe\u8ba1\u5b9e\u8df5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"G0Mha\">1.8.1 \u9700\u6c42\u8bf4\u660e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u4c819668\">\u8bbe\u8ba1<code>product_info<\/code>\u8868\uff0c\u5b58\u50a8\u5546\u54c1\u4fe1\u606f\uff0c\u9700\u5305\u542b\u540d\u79f0\u3001\u4ef7\u683c\u3001\u751f\u4ea7\u65e5\u671f\u7b49\u5b57\u6bb5\uff0c\u5b57\u7b26\u96c6\u4e3aUTF8MB4\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u5b57\u6bb5<\/td><td>\u8981\u6c42<\/td><\/tr><tr><td>\u4e3b\u952e<\/td><td>\u81ea\u589e<\/td><\/tr><tr><td>\u5546\u54c1\u540d\u5b57<\/td><td>\u5305\u62ec\u4e2d\u82f1\u6587\uff0c50\u4e2a\u5b57\u7b26\u4ee5\u5185<\/td><\/tr><tr><td>\u5546\u54c1\u4ef7\u683c<\/td><td>\u4e0d\u8d85\u8fc7\u767e\u4e07\uff0c\u7cbe\u786e\u5230\u5c0f\u6570\u70b9\u540e\u4e24\u4f4d<\/td><\/tr><tr><td>\u5546\u54c1\u751f\u4ea7\u65e5\u671f<\/td><td>\u5305\u62ec\u5e74\u6708\u65e5\u548c\u65f6\u5206\u79d2<\/td><\/tr><tr><td>\u5546\u54c1\u5382\u5546<\/td><td>\u5305\u62ec\u4e2d\u82f1\u6587\uff0c50\u4e2a\u5b57\u7b26\u4ee5\u5185<\/td><\/tr><tr><td>\u5546\u54c1\u5206\u7c7b<\/td><td>\u4f7f\u7528\u679a\u4e3e\u7c7b\u578b\uff0c\u5305\u62ec<code>\u6d17\u6f31\u65e5\u5316<\/code>\u3001<code>\u751f\u9c9c\u6c34\u679c<\/code>\u3001<code>\u4f11\u95f2\u767e\u8d27<\/code>\u3001<code>\u9152\u6c34\u8c03\u6599<\/code>\u3001<code>\u5176\u4ed6<\/code><\/td><\/tr><tr><td>\u8bb0\u5f55\u521b\u5efa\u65f6\u95f4<\/td><td>\u80fd\u8bb0\u5f55\u6bcf\u4e2a\u5546\u54c1\u4fe1\u606f\u7684\u5f55\u5165\u65f6\u95f4<\/td><\/tr><tr><td>\u8bb0\u5f55\u66f4\u65b0\u65f6\u95f4<\/td><td>\u80fd\u8bb0\u5f55\u6bcf\u4e2a\u5546\u54c1\u4fe1\u606f\u7684\u66f4\u65b0\u65f6\u95f4<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"iuAxm\">1.8.2 \u5efa\u8868\u8bed\u53e5\u53ca\u8bbe\u8ba1\u601d\u8def<\/h3>\n\n\n\n<pre id=\"atjNv\" class=\"wp-block-code\"><code>CREATE TABLE product_info(\n  id INT PRIMARY KEY AUTO_INCREMENT COMMENT '\u4e3b\u952e\uff08\u81ea\u589eID\uff09',\n  prod_name VARCHAR(50) NOT NULL COMMENT '\u5546\u54c1\u540d\u79f0\uff08\u53ef\u53d8\u957f\u5ea6\uff0c\u975e\u7a7a\uff09',\n  prod_price DECIMAL(10,2) NOT NULL DEFAULT 0 COMMENT '\u5546\u54c1\u4ef7\u683c\uff08\u5b9a\u70b9\u6570\uff0c\u7cbe\u786e\u5230\u5206\uff09',\n  prod_date TIMESTAMP DEFAULT NULL COMMENT '\u751f\u4ea7\u65e5\u671f\uff08\u542b\u65f6\u5206\u79d2\uff09',\n  prod_manufacturer VARCHAR(50) DEFAULT NULL COMMENT '\u5382\u5546\u540d\u79f0\uff08\u53ef\u53d8\u957f\u5ea6\uff09',\n  prod_sort ENUM('\u6d17\u6f31\u65e5\u5316','\u751f\u9c9c\u6c34\u679c','\u4f11\u95f2\u767e\u8d27','\u9152\u6c34\u8c03\u6599','\u5176\u4ed6') DEFAULT NULL COMMENT '\u5546\u54c1\u5206\u7c7b\uff08\u5355\u9009\u679a\u4e3e\uff09',\n  create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '\u8bb0\u5f55\u521b\u5efa\u65f6\u95f4\uff08\u81ea\u52a8\u751f\u6210\uff09',\n  update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '\u8bb0\u5f55\u66f4\u65b0\u65f6\u95f4\uff08\u81ea\u52a8\u66f4\u65b0\uff09',\n  KEY idx_prod_name(prod_name) -- \u540d\u79f0\u7d22\u5f15\uff0c\u4f18\u5316\u67e5\u8be2\n) ENGINE = InnoDB \n  CHARSET=utf8mb4 \n  COLLATE=utf8mb4_0900_ai_ci \n  COMMENT '\u5546\u54c1\u4fe1\u606f\u8868';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u3c2eac6f\"><strong>\u8bbe\u8ba1\u601d\u8def<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4ef7\u683c\u7528<code>DECIMAL(10,2)<\/code>\uff1a\u786e\u4fdd\u91d1\u989d\u7cbe\u5ea6\u65e0\u8bef\u5dee\u3002<\/li>\n\n\n\n<li>\u5206\u7c7b\u7528<code>ENUM<\/code>\uff1a\u9650\u5236\u53ef\u9009\u503c\uff0c\u51cf\u5c11\u9519\u8bef\u6570\u636e\u3002<\/li>\n\n\n\n<li>\u65f6\u95f4\u5b57\u6bb5\u7528<code>TIMESTAMP<\/code>\uff1a\u81ea\u52a8\u7ef4\u62a4\u521b\u5efa\/\u66f4\u65b0\u65f6\u95f4\uff0c\u7b80\u5316\u4ee3\u7801\u3002<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"A47Qc\">1.9 \u7ae0\u672b\u603b\u7ed3<\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u77e5\u8bc6\u70b9<\/td><td>\u9700\u8981\u638c\u63e1\u7684\u5185\u5bb9<\/td><\/tr><tr><td>\u5b57\u7b26\u4e32\u7c7b\u578b<\/td><td>CHAR\u3001VARCHAR\u3001TEXT\u3001BLOB\u3001ENUM\u3001SET<\/td><\/tr><tr><td>\u6574\u6570\u7c7b\u578b<\/td><td>INT\u3001TINYINT\u3001SMALLINT\u3001MEDIUMINT\u3001BIGINT<\/td><\/tr><tr><td>\u6d6e\u70b9\u6570\u548c\u5b9a\u70b9\u6570<\/td><td>FLOAT\u3001DOUBLE\u3001DECIMAL<\/td><\/tr><tr><td>\u65f6\u95f4\u7c7b\u578b<\/td><td>DATE\u3001TIME\u3001YEAR\u3001DATETIME\u3001TIMESTAMP<\/td><\/tr><tr><td>\u5b57\u7b26\u96c6\u5bf9MySQL\u7684\u5f71\u54cd<\/td><td>\u5e38\u7528\u7684\u5b57\u7b26\u96c6\u3001\u5b57\u7b26\u96c6\u8bbe\u7f6e\u4e0d\u5408\u7406\u5bf9MySQL\u7684\u5f71\u54cd<\/td><\/tr><tr><td>MySQL\u5b57\u7b26\u96c6\u8bbe\u7f6e<\/td><td>\u670d\u52a1\u5668\u7ea7\u3001\u6570\u636e\u5e93\u7ea7\u3001\u8868\u7ea7\u3001\u884c\u7ea7\u7684\u5b57\u7b26\u96c6\u8bbe\u7f6e<\/td><\/tr><tr><td>\u5173\u4e8e\u5b57\u7b26\u96c6\u7684\u5efa\u8bae<\/td><td>\u663e\u5f0f\u5b9a\u4e49\u5b57\u7b26\u96c6\u3001\u7edf\u4e00\u5ba2\u6237\u7aef\u548c\u670d\u52a1\u7aef\u7684\u7f16\u7801\u3001\u65e0\u7279\u6b8a\u8bf4\u660e\u65f6\u5efa\u8bae\u4f7f\u7528 utf8mb4<\/td><\/tr><tr><td>\u6848\u4f8b\u6f14\u793a<\/td><td>\u8bbe\u8ba1\u4e00\u5f20\u8868\uff0c\u5e94\u7528\u672c\u7ae0\u6240\u5b66\u7684\u90e8\u5206\u5b57\u6bb5\u7c7b\u578b\u4ee5\u53ca\u5b57\u7b26\u96c6\u8bbe\u7f6e<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5b57\u6bb5\u7c7b\u578b\u9009\u62e9\u9700\u5e73\u8861<strong>\u7cbe\u5ea6\u3001\u6027\u80fd\u3001\u5b58\u50a8<\/strong>\uff08\u5982\u91d1\u878d\u7528DECIMAL\uff0c\u6574\u6570\u7528\u6700\u5c0f\u591f\u7528\u7c7b\u578b\uff09\u3002<\/li>\n\n\n\n<li>\u65f6\u95f4\u7c7b\u578b\u9700\u6839\u636e<strong>\u8303\u56f4\u3001\u65f6\u533a\u9700\u6c42<\/strong>\u9009\u62e9\uff08\u5982\u8de8\u65f6\u533a\u7528TIMESTAMP\uff09\u3002<\/li>\n\n\n\n<li>\u5b57\u7b26\u96c6\u662f\u4e71\u7801\u4e0e\u6027\u80fd\u7684\u5173\u952e\u5f71\u54cd\u56e0\u7d20\uff0c\u9700\u5168\u5c40\u7edf\u4e00\u4e3aUTF8MB4\uff0c\u907f\u514d\u9690\u6027\u95ee\u9898\u3002<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1.1 \u5e38\u89c1\u5b57\u7b26\u4e32\u7c7b\u578b\u53ca\u5e94\u7528\u573a\u666f 1.1.1 \u6838\u5fc3\u5b57\u7b26\u4e32\u7c7b\u578b\u89e3\u6790 1.1.2 \u5b9e\u8df5\u9a8c\u8bc1\uff1a\u7c7b\u578b\u7279\u6027\u5bf9\u6bd4 \u5b9e\u9a8c1\uff1a<\/p>\n<div class=\"more-link\">\n\t\t\t\t <a href=\"https:\/\/yunyanglib.cn\/?p=180\" class=\"link-btn theme-btn\"><span>Read More <\/span> <i class=\"fa fa-caret-right\"><\/i><\/a>\n\t\t\t<\/div>\n","protected":false},"author":1,"featured_media":184,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[16],"class_list":["post-180","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=180"}],"version-history":[{"count":3,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/180\/revisions"}],"predecessor-version":[{"id":183,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/180\/revisions\/183"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/media\/184"}],"wp:attachment":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}