/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 vote198 views1 answer
Mysql history command
SQL
4 votes283 views2 answers
Mysql alter table set column unique
SQL
-1 vote250 views1 answer
Partial search in sql
SQL
0 vote262 views1 answer
Oracle job session
SQL
0 vote197 views1 answer
What is the use of index in mysql table
SQL
9 votes194 views2 answers
Get first 3 letters in sql
SQL
0 vote279 views1 answer
Last date for each user sql
SQL
0 vote200 views1 answer
Insert array into mysql column
SQL
3 votes190 views4 answers
Ubuntu stop mysql
SQL
0 vote194 views1 answer
Low level operator in dbms
SQL

Share