{"id":124,"date":"2023-07-20T10:52:32","date_gmt":"2023-07-20T02:52:32","guid":{"rendered":"https:\/\/jiachen.de.cool\/blog\/?p=124"},"modified":"2023-07-20T10:52:32","modified_gmt":"2023-07-20T02:52:32","slug":"%e5%a4%a7%e5%b0%8f%e5%86%99%e8%bd%ac%e6%8d%a2%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/jiachen.de.cool\/blog\/2023\/07\/20\/%e5%a4%a7%e5%b0%8f%e5%86%99%e8%bd%ac%e6%8d%a2%e5%87%bd%e6%95%b0\/","title":{"rendered":"\u5927\u5c0f\u5199\u8f6c\u6362\u51fd\u6570"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">1\u3001\u5c06\u5b57\u6bcd\u8f6c\u6362\u4e3a\u5927\u5199\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">upper();<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ucase();<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2\u3001\u5c06\u5b57\u6bcd\u8f6c\u6362\u4e3a\u5c0f\u5199\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">lower();<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">lcase();<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql> select upper(\"mysql\"),ucase(\"mYsql\"),lower(\"MYSQL\"),lcase(\"MySQL\");\r\n+----------------+----------------+----------------+----------------+\r\n| upper(\"mysql\") | ucase(\"mYsql\") | lower(\"MYSQL\") | lcase(\"MySQL\") |\r\n+----------------+----------------+----------------+----------------+\r\n| MYSQL          | MYSQL          | mysql          | mysql          |\r\n+----------------+----------------+----------------+----------------+\r\n1 row in set (0.00 sec)\r\n\r\nmysql> select upper(\"--\");\r\n+-------------+\r\n| upper(\"--\") |\r\n+-------------+\r\n| --          |\r\n+-------------+\r\n1 row in set (0.00 sec)\r\n\r\nmysql> select upper(\"--mysql\");\r\n+------------------+\r\n| upper(\"--mysql\") |\r\n+------------------+\r\n| --MYSQL          |\r\n+------------------+\r\n1 row in set (0.00 sec)\r\n\r\nmysql> select upper('--my\u6570\u636e\u5e93');\r\n+------------------------+\r\n| upper('--my\u6570\u636e\u5e93')    |\r\n+------------------------+\r\n| --MY\u6570\u636e\u5e93             |\r\n+------------------------+\r\n1 row in set (0.00 sec)\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1\u3001\u5c06\u5b57\u6bcd\u8f6c\u6362\u4e3a\u5927\u5199\uff1a upper(); ucase(); 2\u3001\u5c06\u5b57\u6bcd\u8f6c\u6362\u4e3a\u5c0f\u5199\uff1a lower(); lcas&hellip; <\/p>\n<p><a class=\"moretag\" href=\"https:\/\/jiachen.de.cool\/blog\/2023\/07\/20\/%e5%a4%a7%e5%b0%8f%e5%86%99%e8%bd%ac%e6%8d%a2%e5%87%bd%e6%95%b0\/\">Read the full article<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[25,26],"class_list":["post-124","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-25","tag-26"],"_links":{"self":[{"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/posts\/124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/comments?post=124"}],"version-history":[{"count":1,"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/posts\/124\/revisions"}],"predecessor-version":[{"id":125,"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/posts\/124\/revisions\/125"}],"wp:attachment":[{"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/media?parent=124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/categories?post=124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/tags?post=124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}