错误信息:
[Err] 1248 - Every derived table must have its own alias
(每个派生表必须有自己的别名。)
修改后:
[Err] 1248 - Every derived table must have its own alias
(每个派生表必须有自己的别名。)
修改后:
delete from Table1 where id in(
select id from (
select id from Table1 b where user_name = '团长' and user_time = '2年' and b.id !=9
) i
)