/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

0 vote344 views1 answer
Oracle current timestamp
SQL
13 votes328 views2 answers
Check if value is null mysql
SQL
4 votes352 views2 answers
Oracle default date format
SQL
2 votes354 views2 answers
Postgres trigger insert into another table
SQL
0 vote326 views1 answer
Write sql query to show the details start from digit
SQL
4 votes362 views2 answers
Float postgres
SQL
0 vote345 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
4 votes331 views2 answers
SELECT table_name FROM user_tables;
SQL
1 vote343 views1 answer
Drop function
SQL
0 vote343 views2 answers
How to set global time_zone in mysql
SQL