/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

10 votes138 views2 answers
Forgot my mysql password mac
SQL
0 vote166 views1 answer
Compare strings lexicographically in sql
SQL
0 vote119 views1 answer
Mysql show category once count how many products
SQL
2 votes137 views2 answers
Create empty table from existing table
SQL
6 votes136 views4 answers
Remove spaces sql server
SQL
0 vote132 views1 answer
Sql query for select from specific columns in a table
SQL
2 votes128 views1 answer
Drop table if exists in postgres
SQL
0 vote121 views1 answer
Import big data to mysql
SQL
0 vote130 views1 answer
Sql server alter table add column tinyint
SQL
-1 vote152 views1 answer
Sql vs nosql or mysql vs mongodb
SQL