-- 下线「订单调整」菜单:由订单详情弹窗内调整替代 -- 影响菜单:sys_menu.code = 'order_adjust'(id: 10000000000000000000000000000022) -- 执行后效果:菜单不再展示,不再参与可用菜单数据 START TRANSACTION; UPDATE `sys_menu` SET `is_del` = 1, `is_active` = 0, `is_visible` = 0, `update_at` = NOW(), `update_by` = 'system' WHERE `code` = 'order_adjust' AND `is_del` = 0; COMMIT; -- 回滚 SQL(按需执行) -- START TRANSACTION; -- UPDATE `sys_menu` -- SET -- `is_del` = 0, -- `is_active` = 1, -- `is_visible` = 1, -- `update_at` = NOW(), -- `update_by` = 'system' -- WHERE `code` = 'order_adjust'; -- COMMIT;