Postgres操作之Insert select合用

金鱼kk

于 2022-10-11 22:19:32 发布

阅读量1.5k

点赞数

分类专栏： Postgres 文章标签： sql 数据库

本文链接：https://blog.youkuaiyun.com/weixin_44548228/article/details/127272966

版权

Postgres 专栏收录该内容

16 篇文章

订阅专栏

insert into t_user_channels (user_id, channel_id, device_id, related_user, add_time)

select 123456 as user_id,  'ss' as channel_id, device_id as device_id, '0' as related_user, '2020-11-20 10:55:00' as add_time from t_channels 

where id = '71000000001180000008' on conflict(user_id, channel_id, device_id) do update set add_time = '2020-11-20 10:55:00';