mysqldelete操作

2015-11-21 01:55:39 · 作者: · 浏览: 4

delete from account.comp_account_action caa where caa.account_action_code in (10950112,10950113,10950114,10950115);

sql中使用别名删除直接报错,改为下面格式即可

delete from account.comp_account_action where account_action_code in (10950112,10950113,10950114,10950115);