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';
