/SQL/Mysql update table from another table

Mysql update table from another table

Mysql update field from one table to another

UPDATE MY_TABLE AS t1
INNER JOIN MY_OTHER_TABLE AS t2 ON t1.COLID = t2.COLID
SET t1.COL1 = t2.COL1, t1.COL2 = t2.COL2
WHERE t1.COL3 = 'OK';

Mysql update table from another table

UPDATE tableB
INNER JOIN tableA ON tableB.name = tableA.name
SET tableB.value = IF(tableA.value > 0, tableA.value, tableB.value)
WHERE tableA.name = 'Joe'

Source: stackoverflow.com

Similar codes

3 votes148 views1 answer
System.debug apex
SQL
1 vote179 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote199 views1 answer
Get last updated row sql server
SQL
0 vote202 views1 answer
Postgresql custom order by
SQL
1 vote187 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote197 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote180 views1 answer
Json not contains mysql
SQL
4 votes234 views1 answer
Sql delete multiple conditions
SQL
1 vote144 views1 answer
Oracle boolean to varchar
SQL
0 vote229 views1 answer
Postgresql alter table sequence
SQL