普通删除sql delete from Person where id=3; 有别名的情况下: delete p from Person p where not exists(select 1 from PatientGroup_Person pgp where p.id=pgp.person_id);
查看原文:http://www.baowenwei.com/archives/910
mysql 删除数据时使用别名
最新推荐文章于 2021-01-19 11:49:12 发布
普通删除sql delete from Person where id=3; 有别名的情况下: delete p from Person p where not exists(select 1 from PatientGroup_Person pgp where p.id=pgp.person_id);
查看原文:http://www.baowenwei.com/archives/910