[SQL]DELETE FROM material_stock_unpack t WHERE t.relation = 'M0000032822';
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't WHERE t.relation = 'M0000032822'' at line 1
执行sql : DELETE FROM material_stock_unpack t WHERE t.relation = 'M0000032822'; 报上面的错误,语法也没有错误,不知道原因,尝试把别名去掉,执行成功,原来在MySQL中,执行删除语句不能用别名。但是把这个SQL放入到oracle数据库中执行,完全没有问题。