Home / Questions / 482726
Accepted
Julian
Asked: 2022-09-08 04:13:43 +0800 CST 2022-09-08 04:13:43 +0800 CST

Problem with an UPDATE of a SELECT in MySQL

  • 772

good morning. I come to ask for help. I can't see what is wrong with this statement.

UPDATE
    P
SET
    P.id_articulo = A.id_articulo
FROM
    articulos_x_proveedor AS P
    INNER JOIN articulos AS A
    ON A.codigo_interno = P.cod_proveedor
WHERE
    P.id_articulo = 0 AND P.papelera = 0 
AND A.papelera = 0 AND A.id_agenda = 2395

When executing the query it returns me this:

Error Code : 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 'FROM articles_x_proveedor AS P INNER JOIN articles AS A ON A.co' at line 5 (0 ms taken)

I would appreciate the help!

mysql

1 Answers

  1. Best Answer

    You could do what you want with a simple subquery directly assigned to the column:

    UPDATE articulos_x_proveedor SET id_articulo = 
(SELECT A.id_articulo FROM articulos AS A WHERE A.codigo_interno = cod_proveedor 
AND A.papelera=0 AND A.id_agenda=2395)
WHERE id_articulo=0 AND papelera=0
    • 4