{"id":7709,"date":"2022-10-17T11:19:20","date_gmt":"2022-10-17T03:19:20","guid":{"rendered":"http:\/\/123.57.164.21\/?p=7709"},"modified":"2022-10-17T11:35:35","modified_gmt":"2022-10-17T03:35:35","slug":"sql%e7%9a%84-select-for-update-tips","status":"publish","type":"post","link":"https:\/\/92it.top\/?p=7709","title":{"rendered":"SQL\u7684 Select For Update Tips"},"content":{"rendered":"\n<p><strong>\u60b2\u89c2\u9501\u548c\u4e50\u89c2\u9501<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u4e50\u89c2\u9501\u548c\u60b2\u89c2\u9501\u53ea\u662f\u4e24\u4e2a\u52a0\u9501\u7684\u601d\u8def\uff0c\u5176\u5b9e\u73b0\u65b9\u5f0f\u591a\u79cd\u591a\u6837\u3002\u4ee5\u4e0b\u4e3e\u51e0\u4e2a\u5728\u6570\u636e\u5e93\u4e2d\u7684\u4f8b\u5b50\u3002<br>\u5bf9\u4e8e\u4e00\u6b21\u7684\u6570\u636e\u4fee\u6539\uff0c\u6211\u4eec\u53ef\u4ee5\u5927\u6982\u5c06\u5176\u5206\u4e3a\u4e09\u6b65\u3002<\/p>\n\n\n\n<ul><li>\u83b7\u53d6\u6570\u636e<\/li><li>\u4fee\u6539\u6570\u636e<\/li><li>\u63d0\u4ea4\u4fee\u6539<\/li><\/ul>\n\n\n\n<p>\u8fd9\u91cc\u5047\u8bbeA\u3001B\u4e24\u4e2a\u89d2\u8272\u5bf9\u6570\u636e\u8fdb\u884c\u4fee\u6539\u3002<\/p>\n\n\n\n<p><strong>\u4e50\u89c2\u9501<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u4e50\u89c2\u9501\u5bf9\u6570\u636e\u4fdd\u6301\u4e00\u4e2a\u4e50\u89c2\u6001\u5ea6\uff08\u5927\u6982\u7387\u4e0d\u4f1a\u6709\u4eba\u548c\u6211\u62a2\uff09\u3002A\u89d2\u8272\u83b7\u53d6\u6570\u636e\u3001\u4fee\u6539\u6570\u636e\u65f6\u4e0d\u4f1a\u5bf9\u6570\u636e\u52a0\u9501\uff0c\u53ea\u6709\u5728\u63d0\u4ea4\u4fee\u6539\u65f6\u624d\u4f1a\u5224\u65ad\u4e2d\u95f4\u662f\u5426\u6709\u5176\u4ed6\u4eba\u5bf9\u6570\u636e\u8fdb\u884c\u4e86\u4fee\u6539\u3002\uff08\u56e0\u4e3a\u6ca1\u6709\u5bf9\u6570\u636e\u52a0\u9501\uff0cB\u89d2\u8272\u53ef\u5728A\u89d2\u8272\u83b7\u53d6\u6570\u636e\u540e\uff0c\u4e5f\u83b7\u53d6\u5230\u6570\u636e\uff0c\u751a\u81f3\u6bd4A\u63d0\u524d\u63d0\u4ea4\u6570\u636e\u4fee\u6539\uff09\u3002<\/p>\n\n\n\n<p> \u4e00\u4e2a\u7b80\u5355\u7684\u5b9e\u73b0\u5c31\u662f\u7ed9\u6570\u636e\u6dfb\u52a0\u7248\u672c\u53f7\u5b57\u6bb5(\u6b64\u5904\u547d\u540d\u4e3aversion)\uff0c\u4f8b\u5982A\u89d2\u8272\u5728\u83b7\u53d6\u6570\u636e\u9636\u6bb5\uff0c\u83b7\u53d6\u5230\u7684\u7248\u672c\u53f7\u4e3a<strong>V1<\/strong>\uff0c\u5219\u5728\u63d0\u4ea4\u4fee\u6539\u9636\u6bb5\u7684\u6267\u884c\u8bed\u53e5\u5c31\u4e3a<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">update .......where version = V1<\/pre>\n\n\n\n<p>\u8fd9\u6837\u5f53\u6570\u636e\u5728\u4e2d\u9014\u88abB\u89d2\u8272\u4fee\u6539\u540e\uff0cversion\u5b57\u6bb5\u5c06\u4e0d\u4e3a\u539f\u6765\u7684V1\uff0c\u6b64\u6761\u66f4\u65b0\u8bed\u53e5\u4e5f\u5c31\u5931\u6548\u4e86\u3002\u4e0d\u4f1a\u5bfc\u81f4\u6570\u636e\u66f4\u65b0\u5f02\u5e38\u3002<\/p>\n\n\n\n<p><strong>\u60b2\u89c2\u9501<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u60b2\u89c2\u9501\u5bf9\u6570\u636e\u4fdd\u6301\u4e00\u4e2a\u60b2\u89c2\u6001\u5ea6\uff08\u7edd\u903c\u4f1a\u6709\u4eba\u6765\u548c\u6211\u62a2\uff09\uff0c\u5219\u5728\u89d2\u8272A\u83b7\u53d6\u6570\u636e\u540e\uff0c\u5c31\u5bf9\u6570\u636e\u8fdb\u884c\u4e86\u52a0\u9501\uff0c\u76f4\u5230\u4fee\u6539\u6570\u636e\u3001\u63d0\u4ea4\u4fee\u6539\u540e\u624d\u5c06\u9501\u91ca\u653e\u3002\u4e2d\u9014\u7531\u4e8e\u6570\u636e\u5df2\u7ecf\u88ab\u52a0\u9501\uff0c\u89d2\u8272B\u538b\u6839\u8bfb\u4e0d\u6570\u636e\uff0c\u4e5f\u5c31\u4e0d\u5b58\u5728\u4e2d\u9014\u88ab\u4fee\u6539\u7684\u60c5\u51b5\u3002<\/p>\n\n\n\n<p><strong>Select For Update\u67e5\u8be2<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u56de\u5230\u6b63\u9898\uff0c\u6211\u4eec\u5e73\u65f6\u4f7f\u7528\u7684select\u8bed\u53e5\u53ea\u662f\u67e5\u8be2\uff0c\u4e0d\u6d89\u53ca\u4fee\u6539\uff0c\u6545\u4e0d\u5b58\u5728\u52a0\u9501\u7684\u6982\u5ff5\u3002\u800cselect * for update \u4ece\u5b57\u9762\u610f\u601d\u5c31\u53ef\u4ee5\u77e5\u9053\uff0c\u8be5\u8bed\u53e5\u4e0d\u5355\u5355\u662f\u67e5\u8be2\uff0c\u800c\u662f\u4e3a\u4e86\u540e\u7eed\u7684\u4fee\u6539\uff0c\u6240\u4ee5\u662f\u8981\u5bf9\u6570\u636e\u52a0\u9501\u7684\uff0c\u5e76\u4e14\u662f\u60b2\u89c2\u9501\u3002\u6b64\u65f6\u6309\u7167select \u4e2dwhere\u6761\u4ef6\u5b57\u6bb5\uff0c\u53c8\u53ef\u5206\u4e3a\u884c\u9501\u548c\u8868\u9501\u3002<br>\u5728\u8fd9\u91cc\u6211\u4eec\u65b0\u5efa\u4e00\u4e2a\u6570\u636e\u5e93\u6765\u8ba8\u8bba\uff0c\u96c7\u5458\u8868\uff0c\u9500\u552e\u90e814\u4eba\uff0c\u6280\u672f\u90e810\u4eba\uff0c\u517124\u4eba\u3002\uff08\u5728\u8fd9\u91cc\u7559\u610f\u4ee5\u4e0b\u4eba\u6570\u6bd4\u4f8b\u3002\u540e\u9762\u8fd9\u4e2a\u6bd4\u4f8b\u4f1a\u5f71\u54cd\u67e5\u8be2\uff09\u3002\u5efa\u8868\u8bed\u53e5\u653e\u5728\u5e16\u5b50\u6700\u540e\u3002<\/p>\n\n\n\n<p>Select\u67e5\u8be2\u662f\u4e0d\u52a0\u9501\u7684\uff0cSelect\u2026For Update\u662f\u4f1a\u52a0\u9501\u7684\uff0c\u800c\u4e14\u662f<a rel=\"noreferrer noopener\" href=\"https:\/\/so.csdn.net\/so\/search?q=%E6%82%B2%E8%A7%82%E9%94%81&amp;spm=1001.2101.3001.7020\" target=\"_blank\">\u60b2\u89c2\u9501<\/a>\uff0c\u4f46\u662f\u5728\u4e0d\u540c\u67e5\u8be2\u6761\u4ef6\u65f6\u5019\u52a0\u7684\u9501\u7684\u7c7b\u578b\uff08\u884c\u9501\uff0c\u8868\u9501\uff09\u662f\u4e0d\u540c\u7684\u3002<\/p>\n\n\n\n<ul><li>\u5728where \u540e\u9762\u67e5\u8be2\u6761\u4ef6\u662f\u4e3b\u952e\u7d22\u5f15\uff0c<a rel=\"noreferrer noopener\" href=\"https:\/\/so.csdn.net\/so\/search?q=%E5%94%AF%E4%B8%80%E7%B4%A2%E5%BC%95&amp;spm=1001.2101.3001.7020\" target=\"_blank\">\u552f\u4e00\u7d22\u5f15<\/a>\u65f6\u5019\u662f\u884c\u9501<\/li><li>\u67e5\u8be2\u6761\u4ef6\u662f\u666e\u901a\u5b57\u6bb5\u65f6\u5019\u52a0\u7684\u662f\u8868\u9501<\/li><\/ul>\n\n\n\n<p><strong>where \u4e3b\u952e\u5b57\u6bb5<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u5f53\u67e5\u8be2\u7528\u5230\u7d22\u5f15\u65f6\u662f\u884c\u9501\u3002<\/p>\n\n\n\n<p>\u6211\u4eec\u5728<strong>\u4f1a\u8bdd1<\/strong>\u4e2d\u91c7\u7528\u4e3b\u952e\u6765\u67e5\u8be2\u4e00\u6761\u4fe1\u606f\uff0c\u53ef\u6b63\u5e38\u663e\u793a\u7ed3\u679c\u3002\u7531\u4e8e\u6ca1\u6709\u6267\u884crollback\uff0c\u8be5\u4e8b\u52a1\u6ca1\u6709\u9000\u51fa\uff0c\u6b64\u65f6\u8be5\u6761\u6570\u636e\u88ab\u884c\u9501\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/image-187-1024x699.png\" alt=\"\" class=\"wp-image-7714\" width=\"583\" height=\"398\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-187-1024x699.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-187-300x205.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-187-768x524.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-187-830x567.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-187-230x157.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-187-350x239.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-187-480x328.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-187.png 1450w\" sizes=\"(max-width: 583px) 100vw, 583px\" \/><\/figure><\/div>\n\n\n\n<p>\u6211\u4eec\u65b0\u5efa\u4e00\u4e2a<strong>\u4f1a\u8bdd2<\/strong>\u540c\u6837\u901a\u8fc7\u4e3b\u952e\u67e5\u8be2\u4e3b\u952e\u4e3a111\u548c112\u7684\u6570\u636e\u3002\u6b64\u65f6\u7531\u4e8e<strong>\u4f1a\u8bdd1<\/strong>\u884c\u9501\u4e86\u6570\u636e111\uff0c\u4f1a\u5bfc\u81f4<strong>\u4f1a\u8bdd2<\/strong>\u4e2d\u7684\u67e5\u8be2111\u88ab\u963b\u585e\u3002\u800c<strong>\u4f1a\u8bdd2<\/strong>\u67e5\u8be2112\u53ef\u6b63\u5e38\u67e5\u51fa\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/image-188-1024x759.png\" alt=\"\" class=\"wp-image-7715\" width=\"588\" height=\"435\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-188-1024x759.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-188-300x222.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-188-768x569.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-188-830x615.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-188-230x170.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-188-350x259.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-188-480x356.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-188.png 1458w\" sizes=\"(max-width: 588px) 100vw, 588px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/image-189-1024x684.png\" alt=\"\" class=\"wp-image-7716\" width=\"596\" height=\"398\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-189-1024x684.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-189-300x200.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-189-768x513.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-189-830x554.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-189-230x154.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-189-350x234.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-189-480x320.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-189.png 1456w\" sizes=\"(max-width: 596px) 100vw, 596px\" \/><\/figure><\/div>\n\n\n\n<p><strong>where\u666e\u901a\u5b57\u6bb5<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u5f53\u67e5\u8be2\u7528\u6ca1\u7528\u5230\u7d22\u5f15\u65f6\u662f\u8868\u9501\u3002<\/p>\n\n\n\n<p>\u6211\u4eec\u5728<strong>\u4f1a\u8bdd1<\/strong>\u4e2d\u91c7\u7528\u666e\u901a\u5b57\u6bb5\u6765\u67e5\u8be2\u4e00\u6761\u4fe1\u606f\uff0c\u53ef\u6b63\u5e38\u663e\u793a\u7ed3\u679c\u3002\u7531\u4e8e\u6ca1\u6709\u6267\u884crollback\uff0c\u8be5\u4e8b\u52a1\u6ca1\u6709\u9000\u51fa\uff0c\u6b64\u65f6\u8868\u8868\u88ab\u8868\u9501\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/image-190-1024x742.png\" alt=\"\" class=\"wp-image-7717\" width=\"603\" height=\"436\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-190-1024x742.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-190-300x217.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-190-768x557.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-190-830x601.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-190-230x167.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-190-350x254.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-190-480x348.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-190.png 1482w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/figure><\/div>\n\n\n\n<p>\u6211\u4eec\u5728<strong>\u4f1a\u8bdd2<\/strong>\u4e2d\u91c7\u7528\u666e\u901a\u5b57\u6bb5\u6765\u67e5\u8be2\u4e00\u6761\u4fe1\u606f\uff0c\u53d1\u73b0\u65e0\u8bba\u4f7f\u7528\u4ec0\u4e48\u6765\u67e5\u8be2\uff0c\u5747\u88ab\u963b\u585e\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/image-191-1024x666.png\" alt=\"\" class=\"wp-image-7718\" width=\"633\" height=\"412\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-191-1024x666.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-191-300x195.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-191-768x500.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-191-830x540.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-191-230x150.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-191-350x228.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-191-480x312.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-191.png 1482w\" sizes=\"(max-width: 633px) 100vw, 633px\" \/><\/figure><\/div>\n\n\n\n<p><strong>\u8fdb\u9636<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u5f53\u6211\u4eec\u4f7f\u7528\u975e\u7d22\u5f15\u5b57\u6bb5\u8fdb\u884cselect \u2026 for update \u65f6\uff0c\u4f1a\u9020\u6210\u8868\u9501\u3002\u6b64\u65f6\u6211\u4eec\u5c1d\u8bd5\u5c06\u8be5\u975e\u7d22\u5f15\u5b57\u6bb5\u8bbe\u7f6e\u4e3a\u7d22\u5f15\u3002<br>\u5c06<strong>dname<\/strong>\u8bbe\u7f6e\u4e3a\u7d22\u5f15\u540e\uff0c\u5728<strong>\u4f1a\u8bdd1<\/strong>\u4e2d\u6267\u884c\u67e5\u8be2<strong>dname = \u2018\u9500\u552e\u90e8\u2019<\/strong>\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/image-192-1024x705.png\" alt=\"\" class=\"wp-image-7719\" width=\"550\" height=\"378\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-192-1024x705.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-192-300x206.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-192-768x528.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-192-830x571.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-192-230x158.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-192-350x241.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-192-480x330.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-192.png 1462w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/figure><\/div>\n\n\n\n<p>\u4f1a\u5f97\u51fa\u7ed3\u679c\uff0c\u5728<strong>\u4f1a\u8bdd2<\/strong>\u4e2d\u6211\u4eec\u67e5\u8be2<strong>\u9500\u552e\u90e8<\/strong>\u7684\u5458\u5de5\uff0c\u53d1\u73b0\u963b\u585e\u3002\u67e5\u8be2<strong>\u975e\u9500\u552e\u90e8<\/strong>\u7684\u5458\u5de5\uff0c\u53ef\u51fa\u7ed3\u679c\u3002\u6210\u529f\u5c06\u8868\u9501\u8f6c\u5316\u4e3a\u4e86\u884c\u9501\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/image-193-1024x463.png\" alt=\"\" class=\"wp-image-7720\" width=\"570\" height=\"257\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-193-1024x463.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-193-300x136.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-193-768x348.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-193-830x376.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-193-230x104.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-193-350x158.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-193-480x217.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-193.png 1454w\" sizes=\"(max-width: 570px) 100vw, 570px\" \/><\/figure><\/div>\n\n\n\n<p>\u6b64\u65f6\u6211\u4eec\u8c03\u6574\u8868\u4e2d\u7684\u90e8\u95e8\uff0c\u4f7f\u5f97\u6570\u636e\u5927\u90e8\u5206\u4e3a<strong>\u9500\u552e\u90e8<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/image-194-1024x579.png\" alt=\"\" class=\"wp-image-7721\" width=\"627\" height=\"354\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-194-1024x579.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-194-300x170.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-194-768x435.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-194-830x470.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-194-230x130.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-194-350x198.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-194-480x272.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-194.png 1474w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/figure><\/div>\n\n\n\n<p>\u8fd9\u4e2a\u65f6\u5019\u5728\u548c\u4e0a\u9762\u4e00\u6837\u505a\u76f8\u540c\u67e5\u8be2\uff0c\u4f1a\u53d1\u73b0\uff0c\u9664\u4e86<strong>\u9500\u552e\u90e8<\/strong>\u6570\u636e\u88ab\u9501\u5b9a\u5916\uff0c<strong>\u6280\u672f\u90e8<\/strong>\u6570\u636e\u4e5f\u88ab\u9501\u5b9a\u3002\u53d8\u6210\u4e86\u8868\u9501\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/image-195-1024x339.png\" alt=\"\" class=\"wp-image-7722\" width=\"644\" height=\"213\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-195-1024x339.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-195-300x99.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-195-768x255.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-195-830x275.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-195-230x76.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-195-350x116.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-195-480x159.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/image-195.png 1460w\" sizes=\"(max-width: 644px) 100vw, 644px\" \/><\/figure><\/div>\n\n\n\n<p>\u539f\u56e0\u662f\u5f53\u7d22\u5f15\u5217\u4e2d\uff0c\u6240\u67e5\u7684\u503c\u5360\u7edd\u5927\u90e8\u5206\u65f6\uff0c\u4f1a\u8d70<strong>\u5168\u7d22\u5f15\u626b\u63cf<\/strong>\uff0c\u76f8\u5f53\u4e0e\u5c06\u8be5\u5b57\u6bb5\u770b\u6210\u666e\u901a\u5b57\u6bb5\u6765\u64cd\u4f5c\uff0c\u6545\u4f1a\u5f62\u6210\u8868\u9501\u3002<\/p>\n\n\n\n<p><strong>\u7528\u5230\u7684sql<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE `employee` (\n  `empno` int(11) NOT NULL,\n  `ename` varchar(255) DEFAULT NULL,\n  `job` varchar(255) DEFAULT NULL,\n  `hiredate` datetime DEFAULT NULL,\n  `sal` varchar(255) DEFAULT NULL,\n  `dname` varchar(255) DEFAULT NULL,\n  PRIMARY KEY (`empno`),\n  KEY `dname_index` (`dname`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">INSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (111, '\u9500\u552e1', '\u9500\u552e', '2022-08-20 16:14:18', '800', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (112, '\u9500\u552e2', '\u9500\u552e', '2022-08-20 16:14:12', '80012', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (113, '\u9500\u552e3', '\u9500\u552e', '2022-08-20 16:14:13', '80013', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (114, '\u9500\u552e4', '\u9500\u552e', '2022-08-20 16:14:14', '80014', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (115, '\u9500\u552e5', '\u9500\u552e', '2022-08-20 16:14:15', '80015', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (116, '\u9500\u552e6', '\u9500\u552e', '2022-08-20 16:14:16', '80016', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (117, '\u9500\u552e7', '\u9500\u552e', '2022-08-20 16:14:17', '80017', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (118, '\u9500\u552e8', '\u9500\u552e', '2022-08-20 16:14:18', '80018', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (119, '\u9500\u552e9', '\u9500\u552e', '2022-08-20 16:14:19', '80019', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (120, '\u9500\u552e10', '\u9500\u552e', '2022-08-20 16:14:20', '80020', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (121, '\u9500\u552e11', '\u9500\u552e', '2022-08-20 16:14:21', '80021', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (122, '\u9500\u552e12', '\u9500\u552e', '2022-08-20 16:14:22', '80022', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (123, '\u9500\u552e13', '\u9500\u552e', '2022-08-20 16:14:23', '80023', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (124, '\u9500\u552e14', '\u9500\u552e', '2022-08-20 16:14:24', '80024', '\u9500\u552e\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (125, '\u6280\u672f1', '\u6280\u672f', '2022-08-20 16:14:25', '80025', '\u6280\u672f\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (126, '\u6280\u672f2', '\u6280\u672f', '2022-08-20 16:14:26', '80026', '\u6280\u672f\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (127, '\u6280\u672f3', '\u6280\u672f', '2022-08-20 16:14:27', '80027', '\u6280\u672f\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (128, '\u6280\u672f4', '\u6280\u672f', '2022-08-20 16:14:28', '80028', '\u6280\u672f\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (129, '\u6280\u672f5', '\u6280\u672f', '2022-08-20 16:14:29', '80029', '\u6280\u672f\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (130, '\u6280\u672f6', '\u6280\u672f', '2022-08-20 16:14:30', '80030', '\u6280\u672f\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (131, '\u6280\u672f7', '\u6280\u672f', '2022-08-20 16:14:31', '80031', '\u6280\u672f\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (132, '\u6280\u672f8', '\u6280\u672f', '2022-08-20 16:14:32', '80032', '\u6280\u672f\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (133, '\u6280\u672f9', '\u6280\u672f', '2022-08-20 16:14:33', '80033', '\u6280\u672f\u90e8');\nINSERT INTO `test`.`employee` (`empno`, `ename`, `job`, `hiredate`, `sal`, `dname`) VALUES (134, '\u6280\u672f10', '\u6280\u672f', '2022-08-20 16:14:34', '80034', '\u6280\u672f\u90e8');<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u60b2\u89c2\u9501\u548c\u4e50\u89c2\u9501 \u4e50\u89c2\u9501\u548c\u60b2\u89c2\u9501\u53ea\u662f\u4e24\u4e2a\u52a0\u9501\u7684\u601d\u8def\uff0c\u5176\u5b9e\u73b0\u65b9\u5f0f\u591a\u79cd\u591a\u6837\u3002\u4ee5\u4e0b\u4e3e\u51e0\u4e2a\u5728\u6570\u636e\u5e93\u4e2d\u7684\u4f8b\u5b50\u3002\u5bf9\u4e8e\u4e00\u6b21\u7684\u6570 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"_links":{"self":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/7709"}],"collection":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7709"}],"version-history":[{"count":3,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/7709\/revisions"}],"predecessor-version":[{"id":7723,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/7709\/revisions\/7723"}],"wp:attachment":[{"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}