- use `qc`;
- UPDATE `sys_permission` SET is_deleted = 'Y' WHERE permissionUrl LIKE '/console%' AND is_deleted='N';
- UPDATE sys_menu_permission SET is_deleted='Y'
- where permission_id in(
- select id from `sys_permission` WHERE permissionUrl LIKE '/console%') AND is_deleted='N';
- UPDATE sys_role_permission SET is_deleted='Y'
- where permission_id in(
- select id from `sys_permission` WHERE permissionUrl LIKE '/console%') AND is_deleted='N';
|