/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 vote266 views1 answer
Ffeathers express mysql application users login
SQL
1 vote349 views1 answer
Mysql get max value and id
SQL
1 vote301 views1 answer
Isnull sql server
SQL
0 vote265 views1 answer
Low level operator in dbms
SQL
1 vote279 views1 answer
Mysql query where in select
SQL
22 votes273 views4 answers
Show list of users in mysql
SQL
11 votes713 views4 answers
Reset identity column values in sql server
SQL
4 votes268 views2 answers
Error loading MySQLdb module.
SQL
2 votes302 views1 answer
Mysql create user with remote access
SQL
0 vote283 views1 answer
Sql check for null and empty string
SQL