目录
mysql delete的语法别名问题
首先确认，mysql中的delete语句是支持别名的；
在自己书写delete语法时候，语句如下：
delete from tablea a where a.c_pk_id = '123'
但是会报一个别名使用错误，如下：
[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 ‘q
where
q.c_ply_no = ‘1100107000404000220150000001’
and q.n_edr_prj_no = ‘1” at line 3
通过查询资料得知，mysql的delete的语法有些特殊，如下：
delete a from tablea a where a.c_pk_id = '123'
成功删除！！！
比较之后可知道，delete语句在用别名的时候要多写一个别名在delete后边
mysql delete 语句中使用别名 alias
语法：
delete <alias> from <table> <alias> where <alias>.<field>...
别名必需在 delete之后出一次。
多表间删除语法：
delete t1, t2 from t1 inner join t2 inner join t3 where t1.id=t2.id and t2.id=t3.id;
or：
delete from t1, t2 using t1 inner join t2 inner join t3 where t1.id=t2.id and t2.id=t3.id;
left join：
delete t1 from t1 left join t2 on t1.id=t2.id where t2.id is null;
以上为个人经验，希望能给大家一个参考，也希望大家多多支持www.887551.com。