数据库:MySQL 3.6
问题:error in your SQL syntax
错误语句:
delete from security_role_permission rp where rp.permission_id in (2,3) and rp.role_id = 0
delete from security_role_permission as rp where rp.permission_id in (2,3) and rp.role_id = 0
正确语句:
delete rp from security_role_permission rp where rp.permission_id in (2,3) and rp.role_id = 0
delete rp from security_role_permission as rp where rp.permission_id in (2,3) and rp.role_id = 0