删除语句使用别名的用法

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)