Answers for "mysql update where select from another table"

mysql select update same table

UPDATE
    products_description pd INNER JOIN products_description pd2 ON
    (pd.products_id=pd2.products_id AND pd2.language_id=1 AND pd.language_id<>1)
SET pd.products_seo = pd2.products_seo;

Posted by: Guest on February-27-2020

mysql update table from select on another table

UPDATE TableB 
SET TableB.value = (
    SELECT TableA.value 
    FROM TableA
    WHERE TableA.name = TableB.name
);

Posted by: Guest on November-19-2019

Code answers related to "mysql update where select from another table"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql update where select from another table"

Code answers related to "mysql update where select from another table"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql update where select from another table"

Code answers related to "mysql update where select from another table"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us