/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

2 votes205 views1 answer
Oracle sql drop column if exists
SQL
0 vote241 views2 answers
Collation in sql
SQL
0 vote236 views1 answer
How to combine first and last nae into one columb sql
SQL
1 vote240 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote235 views1 answer
Sql server check whether column has same equal values
SQL
0 vote233 views2 answers
How to tun mysql on ubunto
SQL
1 vote229 views1 answer
Sqlalchemy order_by
SQL
20 votes224 views5 answers
Reset auto increment mysql
SQL
12 votes239 views6 answers
How to install sqlite3 in python
SQL
3 votes249 views1 answer
Mysql insert on dupèlicate
SQL

Share