/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

4 votes269 views1 answer
Oracle delete last row
SQL
0 vote308 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote286 views2 answers
Psql commande \gset
SQL
4 votes295 views3 answers
Sql drop primary key
SQL
0 vote272 views1 answer
Sqlite3 pragma foreign keys
SQL
2 votes303 views1 answer
Sql server find columns list in tables
SQL
1 vote283 views2 answers
Remove space in mysql
SQL
0 vote273 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote303 views1 answer
Get only one row in mysql
SQL
0 vote293 views1 answer
Mysql query with sql to get the next row
SQL

Share