INSERT INTO table_name(column_list)
VALUES(value_list)
ON CONFLICT [target] [action];
- column_name:指定表中的列名
- ON CONSTRAINT constraint_ name:约束的名称
- WHERE predicate:where条件
DO NOTHING:什么都不做
- DO UPDATE SET column_1 = value_1, .. WHERE condition:更新指定字段