是否可以执行连接同一个表的删除查询语句,
我尝试过各种连接(内部、左侧),但没有运气 mysql 返回错误
我需要的例子:
DELETE `a` FROM `t1` AS `a`
INNER JOIN `t1` AS `b` USING `some_field_b`
WHERE
`a`.`some_field_a` = 'value_x' AND
`b`.`some_field_a` = 'value_y'
虽然manual http://dev.mysql.com/doc/refman/5.0/en/delete.html似乎建议 INNER JOIN 语法应该在 DELETE 中工作,我知道这种将 join 子句移动到 where 条件的替代方案可以工作......
DELETE a.* FROM t1 AS a, t1 as b
WHERE
a.some_field_b=b.some_field_b AND
a.some_field_a = value_x AND
b.some_field_a = value_y
编辑:我刚刚尝试过这个,这对我有用:
DELETE a FROM t1 AS a
INNER JOIN t1 as b USING(some_field_b)
WHERE
a.some_field_a = value_x AND
b.some_field_a = value_y
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)