![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
PostgreSQL
「已注销」
这个作者很懒,什么都没留下…
展开
-
PostgreSQL中定义常量来使用
SET SESSION "myapp.old" = '';SET SESSION "myapp.new" = '';UPDATE contract_work_calendar_use SET operation_user_name = current_setting ( 'myapp.new' ) WHERE operation_user_name = current_setting ( 'myapp.old' )原创 2021-04-16 09:14:54 · 1163 阅读 · 0 评论 -
PostgreSQL联合查询
多表联合查询UPDATE contract_contract_file SET create_user_name = C.undertake_user_name, create_user_account = C.undertake_user_account FROM contract_contract AS C WHERE contract_id = C.ID AND contract_contract_file.TYPE = 1单表联合查询UPDATE contrac原创 2021-03-10 09:29:47 · 932 阅读 · 0 评论