![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
PostgreSQL
纹化
主人真JB懒, 什么也没留下,!
展开
-
PostgreSQL @DeleteProvider 批量删除
批量删除PostgreSQL @DeleteProvideDELETE FROM table USING ( VALUES ( 'a4862df5d1f94d5db0ddd369dbf02fdd' ), ( '66e82373db3844808478c98de7f5cde4' ), ( 'fd52ee67c3f0494595340d8fb68016be' ) ) AS temp1 ( c_bh ) WHERE table.c_bh = temp1.c_bh;原创 2020-07-20 15:10:36 · 553 阅读 · 0 评论 -
PostgreSQL @UpdateProvider 批量更新
批量更新PostgreSQL @UpdateProvideUPDATE tableSET name = temp1.name FROM ( VALUES ( 'a4862df5d1f94d5db0ddd369dbf02fdd', 'new1' ), ( '66e82373db3844808478c98de7f5cde4', 'new2' ), ( 'fd52ee67c3f0494595340d8fb68016be', 'new6' ) ) AS temp1 ( c_bh, name ) W原创 2020-07-20 15:06:40 · 646 阅读 · 1 评论