PostgreSQL

PostgreSQLのUPDATE文でSELECT文の結果を使用して更新する

投稿日:

UPDATE target set pass = tab.pass
FROM (SELECT id, pass FROM table) tab
WHERE target.id = tab.id ;

-PostgreSQL

Copyright© Webラボラトリ         Created by WATERFALL STUDIO , 2019 All Rights Reserved Powered by STINGER.