数据仓库服务 GaussDB(DWS)-INSERT:IGNORE

时间：2025-02-12 15:04:58

IGNORE

MySQL INSERT语句如果使用IGNORE修饰符，则执行INSERT语句时发生的错误将被忽略。

输入示例

  
       # 如果表中已经存在相同的记录,则忽略当前新数据INSERT IGNORE INTO  exmp_tb2 VALUES(189, '189.23','nice','2017-11-12');INSERT IGNORE INTO  exmp_tb2 VALUES(130,'189.23','nice','2017-11-12');INSERT IGNORE INTO  exmp_tb2 VALUES(120,15.68,'good','2018-11-12');INSERT IGNORE INTO  exmp_tb2 VALUES(DEFAULT,128.23,'nice','2018-10-11');INSERT IGNORE INTO  exmp_tb2 VALUES(DEFAULT,DEFAULT,'nice','2018-12-14');INSERT IGNORE INTO  exmp_tb2 VALUES(DEFAULT,DEFAULT,'nice',DEFAULT);INSERT IGNORE INTO  exmp_tb2 (tb2_id,tb2_price) VALUES(DEFAULT,DEFAULT);INSERT IGNORE INTO  exmp_tb2 (tb2_id,tb2_price,tb2_note) VALUES(DEFAULT,DEFAULT,DEFAULT);INSERT IGNORE INTO  exmp_tb2 (tb2_id,tb2_price,tb2_note,tb2_date) VALUES(DEFAULT,DEFAULT,DEFAULT,DEFAULT);

输出示例

  
       -- 如果表中已经存在相同的记录,则忽略当前新数据INSERT INTO "public"."exmp_tb2"  VALUES (101,'189.23','nice','2017-11-12');INSERT INTO "public"."exmp_tb2"  VALUES (130,'189.23','nice','2017-11-12');INSERT INTO "public"."exmp_tb2"  VALUES (120,15.68,'good','2018-11-12');INSERT INTO "public"."exmp_tb2"  VALUES (DEFAULT,128.23,'nice','2018-10-11');INSERT INTO "public"."exmp_tb2"  VALUES (DEFAULT,DEFAULT,'nice','2018-12-14');INSERT INTO "public"."exmp_tb2"  VALUES (DEFAULT,DEFAULT,'nice',DEFAULT);INSERT INTO "public"."exmp_tb2" ("tb2_id","tb2_price") VALUES (DEFAULT,DEFAULT);INSERT INTO "public"."exmp_tb2" ("tb2_id","tb2_price","tb2_note") VALUES (DEFAULT,DEFAULT,DEFAULT);INSERT INTO "public"."exmp_tb2" ("tb2_id","tb2_price","tb2_note","tb2_date") VALUES (DEFAULT,DEFAULT,DEFAULT,DEFAULT);