“`”<\/p>\n
<strong>SQL \u6807\u51c6\u5b9a\u4e49\u4e86\u56db\u4e2a\u9694\u79bb\u7ea7\u522b\uff1a<\/strong><\/p>\n
<ul><li><strong>READ-UNCOMMITTED(\u8bfb\u53d6\u672a\u63d0\u4ea4)\uff1a<\/strong> \u6700\u4f4e\u7684\u9694\u79bb\u7ea7\u522b\uff0c\u5141\u8bb8\u8bfb\u53d6\u5c1a\u672a\u63d0\u4ea4\u7684\u6570\u636e\u53d8\u66f4\uff0c<strong>\u53ef\u80fd\u4f1a\u5bfc\u81f4\u810f\u8bfb\u3001\u5e7b\u8bfb\u6216\u4e0d\u53ef\u91cd\u590d\u8bfb<\/strong>\u3002<\/li><li><strong>READ-COMMITTED(\u8bfb\u53d6\u5df2\u63d0\u4ea4)\uff1a<\/strong> \u5141\u8bb8\u8bfb\u53d6\u5e76\u53d1\u4e8b\u52a1\u5df2\u7ecf\u63d0\u4ea4\u7684\u6570\u636e\uff0c<strong>\u53ef\u4ee5\u963b\u6b62\u810f\u8bfb\uff0c\u4f46\u662f\u5e7b\u8bfb\u6216\u4e0d\u53ef\u91cd\u590d\u8bfb\u4ecd\u6709\u53ef\u80fd\u53d1\u751f<\/strong>\u3002<\/li><li><strong>REPEATABLE-READ(\u53ef\u91cd\u590d\u8bfb)\uff1a<\/strong> \u5bf9\u540c\u4e00\u5b57\u6bb5\u7684\u591a\u6b21\u8bfb\u53d6\u7ed3\u679c\u90fd\u662f\u4e00\u81f4\u7684\uff0c\u9664\u975e\u6570\u636e\u662f\u88ab\u672c\u8eab\u4e8b\u52a1\u81ea\u5df1\u6240\u4fee\u6539\uff0c<strong>\u53ef\u4ee5\u963b\u6b62\u810f\u8bfb\u548c\u4e0d\u53ef\u91cd\u590d\u8bfb\uff0c\u4f46\u5e7b\u8bfb\u4ecd\u6709\u53ef\u80fd\u53d1\u751f<\/strong>\u3002<\/li><li><strong>SERIALIZABLE(\u53ef\u4e32\u884c\u5316)\uff1a<\/strong> \u6700\u9ad8\u7684\u9694\u79bb\u7ea7\u522b\uff0c\u5b8c\u5168\u670d\u4eceACID\u7684\u9694\u79bb\u7ea7\u522b\u3002\u6240\u6709\u7684\u4e8b\u52a1\u4f9d\u6b21\u9010\u4e2a\u6267\u884c\uff0c\u8fd9\u6837\u4e8b\u52a1\u4e4b\u95f4\u5c31\u5b8c\u5168\u4e0d\u53ef\u80fd\u4ea7\u751f\u5e72\u6270\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c<strong>\u8be5\u7ea7\u522b\u53ef\u4ee5\u9632\u6b62\u810f\u8bfb\u3001\u4e0d\u53ef\u91cd\u590d\u8bfb\u4ee5\u53ca\u5e7b\u8bfb<\/strong>\u3002<\/li><\/ul><\/p>\n
<hr><\/p>\n
<br><\/p>\n
<table class=""table table-bordered""><tbody><tr><td>\u9694\u79bb\u7ea7\u522b<br><\/td><td>\u810f\u8bfb<br><\/td><td>\u4e0d\u53ef\u91cd\u590d\u8bfb<br><\/td><td>\u5e7b\u5f71\u8bfb<br><\/td><\/tr><tr><td>READ-UNCOMMITTED<br><\/td><td>\u221a<br><\/td><td>\u221a<br><\/td><td>\u221a<br><\/td><\/tr><tr><td>READ-COMMITTED<br><\/td><td>\u00d7<br><\/td><td>\u221a<br><\/td><td>\u221a<br><\/td><\/tr><tr><td>REPEATABLE-READ<br><\/td><td>\u00d7<br><\/td><td>\u00d7<br><\/td><td>\u221a<br><\/td><\/tr><tr><td>SERIALIZABLE<br><\/td><td>\u00d7<br><\/td><td>\u00d7<br><\/td><td>\u00d7<br><\/td><\/tr><\/tbody><\/table><\/p>\n
<br><\/p>\n
<pre><code> "“`
\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
“`” <strong>SQL \u6807\u51c6\u5b9a\u4e49\u4e86\u56db\u4e2a\u9694\u79bb\u7ea7\u522b\uff1a<\/stro […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101],"tags":[],"class_list":["post-37446","post","type-post","status-publish","format-standard","hentry","category-c"],"_links":{"self":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/37446","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=37446"}],"version-history":[{"count":1,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/37446\/revisions"}],"predecessor-version":[{"id":37447,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/37446\/revisions\/37447"}],"wp:attachment":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/media?parent=37446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/categories?post=37446"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/tags?post=37446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}