问一个mysql的sql语法问题,谢谢
select * from my_GroupUser t1
where exists(select * from my_group t0 where t0.id=14 and t0.id=t1.groupId)
delete from my_GroupUser t1
where exists(select * from my_group t0 where t0.id=14 and t0.id=t1.groupId)
为什么前面那句sql能执行成功,
而后面那句就错误?
区别只是一个select,一个delete,请指点一下
------解决方案--------------------MYSQL在刪除記錄時表好像不可以用別名
------解决方案--------------------学习了
------解决方案----------------------try
delete my_GroupUser
from my_GroupUser t1
where exists(select * from my_group t0 where t0.id=14 and t0.id=t1.groupId)
或
delete t1
from my_GroupUser t1
where exists(select * from my_group t0 where t0.id=14 and t0.id=t1.groupId)