PostgreSQL @DeleteProvider 批量删除

批量删除

PostgreSQL @DeleteProvider

DELETE 
FROM
	table USING ( VALUES ( 'a4862df5d1f94d5db0ddd369dbf02fdd' ), ( '66e82373db3844808478c98de7f5cde4' ), ( 'fd52ee67c3f0494595340d8fb68016be' ) ) AS temp1 ( c_bh ) 
WHERE
	table.c_bh = temp1.c_bh;

版权声明:本文为weixin_45399923原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。