/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

1 vote316 views2 answers
Mssql show database size
SQL
0 vote309 views1 answer
How to put is null in where in clause
SQL
0 vote309 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote320 views2 answers
Postgres copy table from one schema to another
SQL
1 vote379 views1 answer
STOP message of how many rows affected sql
SQL
0 vote354 views1 answer
Sparql list all graphs
SQL
0 vote333 views1 answer
How to remove quotes from a string in ssis load file
SQL
3 votes328 views1 answer
Start mysql server by terminal in linux
SQL
12 votes289 views4 answers
SQL Where
SQL
1 vote331 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL