postgre更新单列
UPDATE production_fix_event pfe
SET (bad_event_id) = (SELECT be.id FROM bad_event be WHERE pfe.key = be.key);
1:MySQL脚本
UPDATE TABLE A JOIN table2 b ON A.busid = b.busid
SET A.district = b.district;
2:PostgreSQL脚本
①、单列
UPDATE TABLE A
SET ( district ) = ( SELECT district FROM table2 b WHERE A.site = b.site )
WHERE
bustype = 1;
②、多列
UPDATE TABLE A
SET ( column01, colum02, column03 ) = (
SELECT
b.column01, b.column02,
b.column03
FROM
table2 b
WHERE
A.COLUMN = b.COLUMN)
③ 、定义行号,删除重复数据
DELETE
FROM
tableA
WHERE
ID IN (
SELECT ID
FROM
( SELECT ROW_NUMBER () OVER ( PARTITION BY column01, column02 ), ID FROM tableA ) AS T
WHERE
T.ROW_NUMBER > 1
);
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)