{"id":146250,"date":"2020-08-20T00:45:30","date_gmt":"2020-08-19T16:45:30","guid":{"rendered":"http:\/\/4563.org\/?p=146250"},"modified":"2020-08-20T00:45:30","modified_gmt":"2020-08-19T16:45:30","slug":"%e8%af%b7%e6%95%99%e5%a4%a7%e4%bd%acmysql%e7%9a%84varchar%e5%8f%af%e4%bb%a5%e6%8c%89%e6%95%b0%e5%80%bc%e5%88%a4%e6%96%ad%e6%98%af%e5%90%a6%e7%9b%b8%e7%ad%89%e4%b9%88%ef%bc%9f","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=146250","title":{"rendered":"\u8bf7\u6559\u5927\u4f6cMYSQL\u7684varchar\u53ef\u4ee5\u6309\u6570\u503c\u5224\u65ad\u662f\u5426\u76f8\u7b49\u4e48\uff1f"},"content":{"rendered":"\n<p>  \t\t\t\t\t<strong>tradekey1h<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3>\u8bf7\u6559\u5927\u4f6cMYSQL\u7684varchar\u53ef\u4ee5\u6309\u6570\u503c\u5224\u65ad\u662f\u5426\u76f8\u7b49\u4e48\uff1f<\/h3>\n<p>  \t\t\u5b57\u6bb5\u662fvarchar<br \/>  \u5b58\u7684\u503c\u5927\u90e8\u5206\u662f\u6570\u5b57<br \/>  \u6bd4\u5982value=&#8217;00015&#8217;\u6709\u6ca1\u6709\u529e\u6cd5\u5339\u914d\u5230\u503c\u4e3a015\u8bb0\u5f55\uff1f\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>Cstudent<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\t \u672c\u5e16\u6700\u540e\u7531 Cstudent \u4e8e 2020-8-20 00:27 \u7f16\u8f91 <\/p>\n<p> \u4f60\u662f\u53ea\u8981\u505a\u67e5\u8be2\u662f\u5417\uff1f\u53ef\u4ee5\u7528convert\u51fd\u6570<\/p>\n<p>  select value<br \/>  where convert(value,signed) = convert(&#8216;015&#8217;,signed)<\/p>\n<p>  \u8fd9\u6837\u5f53\u4f60\u5f97value\u4e3a&#8217;00015&#8217;\u7684\u65f6\u5019\u4e5f\u80fd\u548c&#8217;015&#8217;\u5bf9\u4e0a\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>h0stl0c<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\t%value%<\/p>\n<p>  \u8fd9\u4e0d\u884c\uff1f<\/p>\n<p>  https:\/\/cdn.jsdelivr.net\/gh\/hishis\/forum-grandmaster-for-discuz\/public\/images\/patch.gif\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>byg<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\t\u90fd\u5148\u8f6c\u6362\u6210int\u518d\u6bd4\u8f83\u4e0d\u5c31\u884c\u4e86\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>tradekey1h<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\tbyg \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-8-19 23:41<br \/>  \u90fd\u5148\u8f6c\u6362\u6210int\u518d\u6bd4\u8f83\u4e0d\u5c31\u884c\u4e86<\/p>\n<p> \u6570\u636e\u5e93\u7ed3\u6784\u4e0d\u6253\u7b97\u52a8<br \/>  \u80fd\u5728\u8bed\u53e5\u4e0a\u89e3\u51b3\u4e48\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>\u4e09\u4e03\u5f00<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\t\u7528\u547d\u4ee4 LIKE + %\u901a\u914d\u7b26\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>tradekey1h<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\tCstudent \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-8-20 00:21<br \/>  \u4f60\u662f\u53ea\u8981\u505a\u67e5\u8be2\u662f\u5417\uff1f\u53ef\u4ee5\u7528convert\u51fd\u6570<\/p>\n<p>  \u8fd9\u6837\u5f53\u4f60\u5f97value\u4e3a&#8217;00015&#8217;\u7684\u65f6\u5019\u4e5f\u80fd\u548c&#8217;015&#8217;\u5bf9\u4e0a &#8230;<\/p>\n<p> 666\t\t\t  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>tradekey1h \u5927\u4f6c\u6709\u8bdd\u8bf4 &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/146250"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=146250"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/146250\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=146250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=146250"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=146250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}