mysql中的ignore关键字可以用来忽略错误。
比如定义如下表:
+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| code_id | int(11) | | PRI | NULL | auto_increment |
| country | varchar(50) | YES | | NULL | |
| province | varchar(50) | YES | | NULL | |
| c_code | varchar(8) | YES | | NULL | |
| p_code | varchar(8) | YES | | NULL | |
+----------+-------------+------+-----+---------+----------------+
执行如下语句插入一条数据:
insert into code values(1,'china','nanjing','86','25');
如果再执行一遍
insert into code values(1,'ch