sql 里面如果有表别名 则要 'delete 表别名 from',如果没有表别名使用'delete from'就行了。
如下是错误:
delete from info i where i.ID >=738 and i.ID <=741;
报错:
表别名附近报错了,
改成:delete i from info i where i.ID >=738 and i.ID <=741;
或者:delete from info where info.ID >=738 and info.ID <=741;
oracle 则没有这种情况,直接delete from 就行了