mysql delete from ... left join .. on ..

最新推荐文章于 2022-04-25 19:45:45 发布

torpidcat

最新推荐文章于 2022-04-25 19:45:45 发布

阅读量2.3k

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/torpidcat/article/details/109270158

版权

mysql 专栏收录该内容

47 篇文章

订阅专栏

使用delete from 表1 left join 表2 删除指定数据，报错，原因是没指定将要删除的表

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 'ot left join xp_order o on ot.order_no = o.order_no where o.draft_no in ('OR2020' at line 2, Time: 0.012000s

原SQL

-- 查询子订单下所有待执行任务
delete from xp_order_task ot left join xp_order o on ot.order_no = o.order_no where o.draft_no in ('OR202010250931221043527507556831') and ot.allocatable = 'Y';

修改为删除指定表中的数据

-- 删除子订单下所有待执行任务
delete ot from xp_order_task ot left join xp_order o on ot.order_no = o.order_no where o.draft_no in ('OR202010250931221043527507556831') and ot.allocatable = 'Y';

参考

https://segmentfault.com/q/1010000010136154

https://www.mysqltutorial.org/mysql-delete-join/