/SQL/Update join

Update join

How to add where command in update comand with joins

UPDATE A
SET foo = B.bar
FROM TableA A
JOIN TableB B
    ON A.col1 = B.colx
WHERE ...

2

Source: stackoverflow.com

Update from select join

UPDATE t1
SET t1.COL1 = t2.COL1, t1.COL2 = t2.COL2
FROM MY_TABLE AS t1
JOIN MY_OTHER_TABLE AS t2 ON t1.COLID = t2.ID
WHERE t1.COL3 = 'OK';

1

Update join

//mysql
UPDATE store_fars
        INNER JOIN
   fake ON store_fars.id = fake.id
SET 
    fake.id = store_fars.id

0

Similar codes

0 vote112 views1 answer
Create column that already exists mysql
SQL
2 votes150 views1 answer
Orcale index size
SQL
-1 vote102 views1 answer
Sql getdate date only
SQL
1 vote107 views1 answer
Woocommerce mysql price table
SQL
0 vote105 views1 answer
Dump only data
SQL
0 vote102 views1 answer
Mysql show category once count how many products
SQL
20 votes107 views2 answers
Mysql bigint max value
SQL
0 vote134 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote121 views1 answer
How to inner join 4 tables in sql
SQL
1 vote115 views1 answer
Sqlserver create table from select
SQL

Share