mysql 查询错误 - where 内的内部联接

Question

我收到此错误：

for the right syntax to use near 'INNER JOIN oferta B ON A.oferta_id_oferta = B.id_oferta AND B.oferta = "design' at line 4

我无法在 where 子句中进行内部联接？或者此查询存在其他问题？

UPDATE `oferta_has_tags` A
    SET fraccao = "1/7"
    WHERE (
    INNER JOIN oferta B
    ON A.oferta_id_oferta = B.id_oferta
    AND B.oferta = "designer"
    AND B.estado = 0)

Answer 1

将其表达为简单的 IN：

UPDATE oferta_has_tags
SET fraccao = '1/7'
WHERE oferta_id_oferta IN (
    SELECT id_oferta 
    FROM oferta
    WHERE oferta = 'designer'
    AND estado = 0)

此外，将双引号 (") 更改为单引号 (') - 使用双引号会导致错误

Answer 2

查询错误。它必须有 SELECT 和 FROM 子句：

它必须是这样的：

更新oferta_has_tags A
设置 fraccao =“1/7”
WHERE id = ( SELECT id FROM yourtable WHERE Something = somevalue )

确保子查询应恰好返回 1 个值。如果要使用上述查询更新多条记录，请将“=”替换为“IN”。像这样：

更新oferta_has_tags A
设置 fraccao =“1/7”
WHERE id IN ( SELECT id FROM yourtable WHERE some = somevalue )

希望它有帮助...