/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

1 vote343 views2 answers
Postgres copy table from one schema to another
SQL
1 vote335 views1 answer
Sql exclude duplicates and find even id
SQL
36 votes361 views6 answers
Rename table sql
SQL
0 vote328 views1 answer
Postgres 11 add primary key
SQL
1 vote343 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote346 views1 answer
Ms sql print more than 1 variable
SQL
9 votes340 views5 answers
Sql limit
SQL
0 vote350 views1 answer
Sqlite3 update select
SQL
2 votes312 views1 answer
Mysql sysdate
SQL
0 vote321 views1 answer
How to find unique key in sql
SQL

Share