1. Oracle语法
delete from Ecc_tcm.prm_skill_assess t where t.oid=1;
2. Mysql语法
delete t from Ecc_tcm.prm_skill_assess t where t.oid=1;
delete from Ecc_tcm.prm_skill_assess where oid=1;
由此可见,mysql在删除时候,如果用别名t,则在delete后面必须加t;
或者干脆不用别名