REPLACE IGNORE

MariaDB [test]> select @@sql_mode;

+---------------------+

| @@sql_mode          |

+---------------------+

| STRICT_TRANS_TABLES |

+---------------------+

1 row in set (0.00 sec)

MariaDB [test]> create table t1(i int primary key, j varchar(10)) engine=innodb;

Query OK, 0 rows affected (0.03 sec)

MariaDB [test]> insert into t1 values('aaa', 'bbb');

ERROR 1366 (22007): Incorrect integer value: 'aaa' for column 'i' at row 1

MariaDB [test]> insert into t1 values('aaa', 'bbb');

ERROR 1366 (22007): Incorrect integer value: 'aaa' for column 'i' at row 1

MariaDB [test]> insert ignore into t1 values('aaa', 'bbb');

Query OK, 1 row affected, 1 warning (0.01 sec)

MariaDB [test]> show warnings;

+---------+------+--------------------------------------------------------+

| Level   | Code | Message                                                |

+---------+------+--------------------------------------------------------+

| Warning | 1366 | Incorrect integer value: 'aaa' for column 'i' at row 1 |

+---------+------+--------------------------------------------------------+

1 row in set (0.00 sec)

MariaDB [test]> select * from t1;

+---+------+

| i | j    |

+---+------+

| 0 | bbb  |

+---+------+

1 row in set (0.00 sec)

MariaDB [test]> replace into t1 values('aaa', 'bbb');

ERROR 1366 (22007): Incorrect integer value: 'aaa' for column 'i' at row 1

MariaDB [test]> replace ignore into t1 values('aaa', 'bbb');

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ignore into t1 values('aaa', 'bbb')' at line 1