/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

1 vote236 views1 answer
Postgres get timestamp
SQL
0 vote256 views1 answer
Connect laravel to mysql on mac
SQL
0 vote304 views1 answer
How to use sqlcommand
SQL
0 vote248 views1 answer
Mysql remove tabs from string
SQL
2 votes357 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote253 views1 answer
Sql get month and year from date
SQL
16 votes237 views3 answers
Order by sql query
SQL
1 vote254 views1 answer
Order by oracle
SQL
1 vote220 views1 answer
Database run
SQL
0 vote247 views3 answers
Sql select statements
SQL