/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 vote97 views1 answer
Sql show all users
SQL
0 vote109 views1 answer
Query by column for substring sql
SQL
0 vote105 views4 answers
Change schema in sql server
SQL
1 vote95 views1 answer
Autocommit mysql
SQL
7 votes109 views4 answers
Index in mysql
SQL
0 vote103 views1 answer
Char varchar nvarchar sql
SQL
0 vote110 views1 answer
Create table database in psql
SQL
2 votes99 views2 answers
Get all tables using like
SQL
0 vote95 views1 answer
Clone table structure mysql
SQL
1 vote118 views1 answer
Increase date by one day in sql oracle
SQL