mysql> drop table test;query ok, 0 rows affected (0.01 sec)mysql> create table test(id int,name varchar(10));query ok, 0 rows affected (0.01 sec)mysql> insert into test values(1,'a1'),(2,'a2'),(3,'a3'),(4,'a4'),(1,'a1');query ok, 5 rows affected (0.00 sec)records: 5 duplicates: 0 warnings: 0mysql> select * from test;+------+------+| id | name |+------+------+| 1 | a1 || 2 | a2 || 3 | a3 || 4 | a4 || 1 | a1 |+------+------+5 rows in set (0.00 sec)mysql> alter ignore table test add unique index idx_id_name (id,name);query ok, 5 rows affected, 1 warning (0.02 sec)records: 5 duplicates: 1 warnings: 1mysql> show warnings;+---------+------+-----------------------------------------------------------------+| level | code | message |+---------+------+-----------------------------------------------------------------+| warning | 1681 | 'ignore' is deprecated and will be removed in a future release. |+---------+------+-----------------------------------------------------------------+1 row in set (0.00 sec)mysql> select * from test;+------+------+| id | name |+------+------+| 1 | a1 || 2 | a2 || 3 | a3 || 4 | a4 |+------+------+4 rows in set (0.00 sec)