mysql - 在表中插入忽略不起作用

Question

insert ignore table ( field2 , name) Values ( 22 , 'value3');

它的添加重复了值

和表结构:

+------------------------+------------------+------+-----+---------+----------------+
| Field                  | Type             | Null | Key | Default | Extra          |
+------------------------+------------------+------+-----+---------+----------------+
| ID                     | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| field2                 | int(10) unsigned | NO   | MUL | NULL    |                |
| field2                 | int(10) unsigned | YES  |     | NULL    |                |
| name                   | varchar(90)      | YES  |     | NULL    |                |
+------------------------+------------------+------+-----+---------+----------------+

输出

1  22 2 value2
2  22 2 value2
3  23 2 value3

Answer 1

您要插入的字段之一是否有索引？如果没有，请添加一个。