/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

0 vote354 views1 answer
Set root password mysql xampp
SQL
23 votes349 views1 answer
How remove column in mysql
SQL
-2 votes365 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote343 views1 answer
Sql bild in function
SQL
1 vote500 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote344 views2 answers
Auto increment column in mysql query results
SQL
0 vote371 views1 answer
Second Step in installing SQL workbench
SQL
0 vote357 views2 answers
Greater than sql server
SQL
7 votes341 views3 answers
How to check table name in current database sql
SQL
0 vote348 views1 answer
No suitable driver found for sqlite
SQL

Share