删除语句使用别名的用法

发布时间 2023-04-28 10:34:22作者: LIUAOJUN

delete FROM fip_classmainprop p where 1 = 1 and not exists (SELECT 1 FROM fip_classdefine c where c.pk_classmainprop = p.pk_classmainprop)
此处会有以下报错

正确写法:
delete p FROM fip_classmainprop p where 1 = 1 and not exists (SELECT 1 FROM fip_classdefine c where c.pk_classmainprop = p.pk_classmainprop)