MySQL ON DUPLICATE KEY 和 PgSQL ON CONFLICT(主键) 处理主键冲突

mysql中

😒表中数据

😒防止主键冲突的SQL

INSERT INTO AUTH_GROUP(ID, NAME) VALUES (1, '贾飞天2') ON DUPLICATE KEY UPDATE NAME = '贾飞天2'

😉执行后

PgSQL中

INSERT INTO AUTH_GROUP(ID, NAME) VALUES (1, '贾飞天2') ON CONFLICT (ID) DO UPDATESET NAME = '贾飞天2'WHEREAUTH_GROUP.ID = 1