{"id":7514,"date":"2023-11-28T19:34:15","date_gmt":"2023-11-28T11:34:15","guid":{"rendered":"https:\/\/wx.kaifamiao.info\/?p=7514"},"modified":"2023-11-28T19:34:21","modified_gmt":"2023-11-28T11:34:21","slug":"mysql-shu-ju-ku-fu-wu-qi-xing-neng-fen-xi-de-fang","status":"publish","type":"post","link":"http:\/\/wx.kaifamiao.info\/index.php\/2023\/11\/28\/mysql-shu-ju-ku-fu-wu-qi-xing-neng-fen-xi-de-fang\/","title":{"rendered":"MySQL\u6570\u636e\u5e93\u670d\u52a1\u5668\u6027\u80fd\u5206\u6790\u7684\u65b9\u6cd5\u547d\u4ee4\u6709\u54ea\u4e9b\uff1f"},"content":{"rendered":"<p>Show status,\u2014\u4e9b\u503c\u5f97\u76d1\u63a7\u7684\u53d8\u91cf\u503c\uff1a<br \/>\n1,Bytes_received\u548cBytes_sent\u670d\u52a1\u5668\u4e4b\u95f4\u6765\u5f80\u7684\u6d41\u91cf\u3002<br \/>\n2\u3001\tCom_*\u670d\u52a1\u5668\u6b63\u5728\u6267\u884c\u7684\u547d\u4ee4\u3002<br \/>\n3\u3001\tCreated_*\u5728\u67e5\u8be2\u6267\u884c\u671f\u9650\u95f4\u521b\u5efa\u7684\u4e34\u65f6\u8868\u548c\u6587\u4ef6\u3002<br \/>\n4,Handler_*\u5b58\u50a8\u5f15\u64ce\u64cd\u4f5c\u3002<br \/>\n5\u3001\tSelect_*\u4e0d\u540c\u7c7b\u578b\u7684\u8054\u63a5\u6267\u884c\u8ba1\u5212\u3002<br \/>\n6,Sort_*\u51e0\u79cd\u6392\u5e8f\u4fe1\u606f\u3002<br \/>\nShow profiles\u662fMySQL\u7528\u6765\u5206\u6790\u5f53\u524d\u4f1a\u8bddSQL\u8bed\u53e5\u6267\u884c\u7684\u8d44\u6e90\u6d88\u8017\u60c5\u51b5<br \/>\nMySQL \u4e2d DATETIME \u548c TIMESTAMP \u7684\u533a\u522b\uff1f<br \/>\n\u5b58\u50a8\u7cbe\u5ea6\u90fd\u4e3a\u79d2<br \/>\n\u533a\u522b:<br \/>\n1\u3001\tDATETIME\u7684\u65e5\u671f\u8303\u56f4\u662f1001\u2014\u20149999\u5e74\uff1bTIMESTAMP\u7684\u65f6\u95f4\u8303\u56f4\u662f1970\u2014\u20142038\u5e74<br \/>\n2\u3001\tDATETIME\u5b58\u50a8\u65f6\u95f4\u4e0e\u65f6\u533a\u65e0\u5173\uff1bTIMESTAMP\u5b58\u50a8\u65f6\u95f4\u4e0e\u65f6\u533a\u6709\u5173\uff0c\u663e\u793a\u7684\u503c\u4e5f\u4f9d\u8d56\u4e8e\u65f6\u533a<br \/>\n3\u3001DATETIME\u7684\u5b58\u50a8\u7a7a\u95f4\u4e3a8\u5b57\u8282\uff1bTIMESTAMP\u7684\u5b58\u50a8\u7a7a\u95f4\u4e3a4\u5b57\u8282<br \/>\nDATETIME\u7684\u9ed8\u8ba4\u503c\u4e3anull\uff1b TIMESTAMP\u7684\u5b57\u6bb5\u9ed8\u8ba4\u4e0d\u4e3a\u7a7a(not null),\u9ed8\u8ba4\u503c\u4e3a\u5f53\u524d\u65f6\u95f4(CURRENT_TIMESTAMP)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Show status,\u2014\u4e9b\u503c\u5f97\u76d1\u63a7\u7684\u53d8\u91cf\u503c\uff1a 1,Bytes_received\u548cBytes_sent\u670d\u52a1\u5668\u4e4b [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[102],"tags":[],"class_list":["post-7514","post","type-post","status-publish","format-standard","hentry","category-db"],"_links":{"self":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/7514","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/comments?post=7514"}],"version-history":[{"count":1,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/7514\/revisions"}],"predecessor-version":[{"id":7515,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/7514\/revisions\/7515"}],"wp:attachment":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/media?parent=7514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/categories?post=7514"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/tags?post=7514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}