/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

3 votes236 views1 answer
Select table column in sql
SQL
0 vote254 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote270 views1 answer
Python mysql check if database exists
SQL
2 votes225 views2 answers
Exec procedure pl sql
SQL
5 votes237 views2 answers
Sql conn
SQL
1 vote251 views1 answer
Add many column to sap iq table
SQL
3 votes265 views2 answers
Oracle sql first day of month
SQL
0 vote253 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote292 views1 answer
How to add auto increment primary key
SQL
1 vote237 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL

Share