mysql delete 删除嵌套语句基本模式

1.创建临时表

2.通过临时表删除相关的数据

3.删除临时表

create table temp as (select sys_user_role_id from sys_user_role a left join sys_user b
    on a.sys_user_id=b.sys_user_id where b.sys_user_id is null);
delete from sys_user_role where sys_user_role_id in (select  sys_user_role_id from temp);
drop table if exists temp;