/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 vote185 views1 answer
Yesql
SQL
0 vote216 views1 answer
Take sql dump in to file
SQL
0 vote158 views2 answers
Delete the last item in a table sql
SQL
5 votes201 views3 answers
MySql get fields of table
SQL
0 vote176 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
2 votes181 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote302 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote237 views1 answer
Prisma transaction
SQL
4 votes178 views2 answers
Mysql select where starts with
SQL
0 vote181 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL