/SQL/Mysql update field from one table to another

Mysql update field from one table to another

Update table from another table mysql

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

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 vote225 views2 answers
Drop tables from local table database postgres
SQL
2 votes223 views1 answer
Oracle run_duration average
SQL
2 votes207 views4 answers
How to find 2nd highest salary in mysql
SQL
14 votes223 views2 answers
Oracle add column with default value
SQL
16 votes251 views1 answer
Sqlserver add column to table
SQL
-1 vote256 views1 answer
Difference berween database and data base management system
SQL
0 vote220 views1 answer
Alter boolean column postgresql
SQL
6 votes213 views3 answers
Mysql change auto_increment start value
SQL
0 vote232 views1 answer
Load data infile mariadb slow
SQL
62 votes237 views8 answers
Mysql add column
SQL