PostgreSQL 批量更新
PostgreSQL About 216 wordsSQL
使用临时表实现批量更新
UPDATE sys_user
SET username = tmp.username
FROM
(VALUES
( 1, 'zs-new' ),
( 2, 'ls-new' ),
( 3, 'ww-new' )
) AS tmp ( id, username )
WHERE
sys_user.id = tmp.id;
Views: 682 · Posted: 2023-11-21
————        END        ————
Give me a Star, Thanks:)
https://github.com/fendoudebb/LiteNote扫描下方二维码关注公众号和小程序↓↓↓
Loading...