{"id":1663,"date":"2026-05-08T09:35:24","date_gmt":"2026-05-08T01:35:24","guid":{"rendered":"https:\/\/blog.ttwow.top\/?p=1663"},"modified":"2026-06-19T21:50:18","modified_gmt":"2026-06-19T13:50:18","slug":"sql-%e8%8e%b7%e5%8f%96%e4%b8%8a%e4%b8%80%e6%9d%a1id","status":"publish","type":"post","link":"https:\/\/blog.ttwow.top\/?p=1663","title":{"rendered":"sql \u83b7\u53d6\u4e0a\u4e00\u6761id"},"content":{"rendered":"<pre><code class=\"language-shell\">-- 1. \u63d2\u5165\u4e3b\u83dc\u5355\nINSERT INTO `system_menu` \n( `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) \nVALUES \n( &#039;\u4e1a\u52a1\u91cd\u542f&#039;, &#039;&#039;, 2, 4, 5184, &#039;business-restart&#039;, &#039;ep:refresh&#039;, &#039;daily\/businessrestart\/index&#039;, 0, b&#039;1&#039;, b&#039;1&#039;, b&#039;1&#039;, &#039;1&#039;, &#039;2026-05-07 15:15:05&#039;, &#039;1&#039;, &#039;2026-05-08 08:58:14&#039;, b&#039;0&#039;);\n\n-- 2. \u83b7\u53d6\u521a\u624d\u751f\u6210\u7684 ID \u5e76\u5b58\u5165\u53d8\u91cf\nSET @last_id = LAST_INSERT_ID();\n\n-- 3. \u540e\u7eed SQL \u4f7f\u7528 @last_id \u4f5c\u4e3a parent_id\nINSERT INTO `system_menu` ( `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `status`, `creator`, `create_time`, `updater`, `update_time`) \nVALUES ( &#039;\u65b0\u589e&#039;, &#039;daily:business-restart:create&#039;, 3, 1, @last_id, &#039;&#039;, 0, &#039;1&#039;, &#039;2026-05-07 15:15:54&#039;, &#039;1&#039;, &#039;2026-05-07 16:09:46&#039;);\n\nINSERT INTO `system_menu` ( `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `status`, `creator`, `create_time`, `updater`, `update_time`) \nVALUES ( &#039;\u4fee\u6539&#039;, &#039;daily:business-restart:update&#039;, 3, 2, @last_id, &#039;&#039;, 0, &#039;1&#039;, &#039;2026-05-07 15:16:07&#039;, &#039;1&#039;, &#039;2026-05-07 15:16:07&#039;);\n\nINSERT INTO `system_menu` ( `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `status`, `creator`, `create_time`, `updater`, `update_time`) \nVALUES ( &#039;\u5220\u9664&#039;, &#039;daily:business-restart:delete&#039;, 3, 3, @last_id, &#039;&#039;, 0, &#039;1&#039;, &#039;2026-05-07 15:16:24&#039;, &#039;1&#039;, &#039;2026-05-07 15:16:24&#039;);\n\nINSERT INTO `system_menu` ( `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `status`, `creator`, `create_time`, `updater`, `update_time`) \nVALUES ( &#039;\u67e5\u8be2&#039;, &#039;daily:business-restart:query&#039;, 3, 4, @last_id, &#039;&#039;, 0, &#039;1&#039;, &#039;2026-05-07 15:16:37&#039;, &#039;1&#039;, &#039;2026-05-07 15:16:37&#039;);\n\nINSERT INTO `system_menu` ( `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `status`, `creator`, `create_time`, `updater`, `update_time`) \nVALUES ( &#039;\u5bfc\u51fa&#039;, &#039;daily:business-restart:export&#039;, 3, 5, @last_id, &#039;&#039;, 0, &#039;1&#039;, &#039;2026-05-07 15:16:49&#039;, &#039;1&#039;, &#039;2026-05-07 15:16:49&#039;);\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8212; 1. \u63d2\u5165\u4e3b\u83dc\u5355 INSERT INTO `system_menu` ( `name`, `permis [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[127],"tags":[73],"class_list":["post-1663","post","type-post","status-publish","format-standard","hentry","category-database-sql","tag-sql"],"_links":{"self":[{"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/posts\/1663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1663"}],"version-history":[{"count":2,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/posts\/1663\/revisions"}],"predecessor-version":[{"id":1665,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/posts\/1663\/revisions\/1665"}],"wp:attachment":[{"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}