/SQL/Mysql update column with value from another table

Mysql update column with value from another table

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

Mysql update column with value from another table

/* Update products position by it's brand's position (from options table) 
with Considering the languages */
UPDATE products
INNER JOIN options ON products.brand = options.value
SET products.brand_position = IF(options.lang = products.lang, options.position, products.brand_position)
WHERE options.name = 'pro_brand';

Similar codes

1 vote388 views4 answers
Psql check tables command
SQL
1 vote394 views1 answer
Update foreign key value in mysql
SQL
10 votes417 views4 answers
Join multiple tables in sql
SQL
15 votes638 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote384 views1 answer
Timestamp(0) postgresql
SQL
0 vote388 views1 answer
Modifier une valeur sql
SQL
0 vote369 views1 answer
Edit a field mysql terminal
SQL
0 vote454 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
1 vote358 views1 answer
Oracle create as select
SQL
0 vote398 views1 answer
Date 3 months from today sql
SQL