0

More than 3 years have passed since last update.

@Masataka_Sugia(masataka sugita)

inner join で update

SQL

Last updated at 2021-01-16Posted at 2021-01-13

初めに

よく使うけど忘れてしまうので記録として。

inner join で結合したものをupdateしたい

UPDATE TableA 
  INNER JOIN TableB ON TableA.code_A = TableB.code_B 
    SET TableA.column_A = TableB.column_B 
  WHERE TableA.flag='1';"

もう一つ結合

UPDATE (TableA 
  INNER JOIN TableB ON TableA.code_A = TableB.code_B)
　INNER JOIN TableC ON TableA.code_A = TableB.code_C 
    SET TableA.column_A = TableB.column_B 
  WHERE TableA.flag='1';"

0

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

0