{"id":7388,"date":"2023-11-28T18:50:32","date_gmt":"2023-11-28T10:50:32","guid":{"rendered":"https:\/\/wx.kaifamiao.info\/?p=7388"},"modified":"2023-11-28T18:50:38","modified_gmt":"2023-11-28T10:50:38","slug":"mysql-zhong-shi-wu-de-ge-li-ji-bie-you-na-xie-mysq","status":"publish","type":"post","link":"http:\/\/wx.kaifamiao.info\/index.php\/2023\/11\/28\/mysql-zhong-shi-wu-de-ge-li-ji-bie-you-na-xie-mysq\/","title":{"rendered":"MySQL\u4e2d\u4e8b\u52a1\u7684\u9694\u79bb\u7ea7\u522b\u6709\u54ea\u4e9b\uff1f MySQL\u7684\u9ed8\u8ba4\u9694\u79bb\u7ea7\u522b\u662f\u4ec0\u4e48\uff1f"},"content":{"rendered":"<p>1\u3001  \u8bfb\u672a\u63d0\u4ea4(Read Uncommitted)<br \/>\n2\u3001  \u8bfb\u5df2\u63d0\u4ea4(Read Committed)<br \/>\n3\u3001  \u53ef\u91cd\u590d\u8bfb(Repeatable Read)<br \/>\n4\u3001  \u4e32\u884c\u5316(SeTializable)<br \/>\nMySQL\u9ed8\u8ba4\u7684\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u662f\u53ef\u91cd\u590d\u8bfb(Repeatable Read)<br \/>\nMySQL \u4e2d DATETIME \u548c TIMESTAMP \u7684\u533a\u522b\uff1f<br \/>\n\u5b58\u50a8\u7cbe\u5ea6\u90fd\u4e3a\u79d2<br \/>\n\u533a\u522b\uff1a<br \/>\n1\u3001  DATETIME\u7684\u65e5\u671f\u8303\u56f4\u662f1001\u2014\u20149999\u5e74\uff1bTIMESTAMP\u7684\u65f6\u95f4\u8303\u56f4\u662f1970\u2014\u20142038\u5e74<br \/>\n2\u3001  DATETIME\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\u3001  DATETIME\u7684\u5b58\u50a8\u7a7a\u95f4\u4e3a8\u5b57\u8282\uff1bTIMESTAMP\u7684\u5b58\u50a8\u7a7a\u95f4\u4e3a4\u5b57\u8282<br \/>\n4\u3001  DATETIME\u7684\u9ed8\u8ba4\u503c\u4e3anull\uff1bTIMESTAMP\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>1\u3001 \u8bfb\u672a\u63d0\u4ea4(Read Uncommitted) 2\u3001 \u8bfb\u5df2\u63d0\u4ea4(Read Committed) 3\u3001 \u53ef\u91cd [&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-7388","post","type-post","status-publish","format-standard","hentry","category-db"],"_links":{"self":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/7388","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=7388"}],"version-history":[{"count":1,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/7388\/revisions"}],"predecessor-version":[{"id":7389,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/7388\/revisions\/7389"}],"wp:attachment":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/media?parent=7388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/categories?post=7388"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/tags?post=7388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}