MySQL INSERT IGNORE Statement

When you use the INSERT statement to add multiple rows to a table and if an error occurs during the processing, MySQL terminates the statement and returns an error. As the result, no rows are inserted into the table.

However, if you use the INSERT IGNORE statement, the rows with invalid data that cause the error are ignored and the rows with valid data are inserted into the table.

The syntax of the INSERT IGNORE statement is as follows:

INSERT IGNORE INTO table(column_list)
VALUES( value_list),
      ( value_list),
      ...

Source: mysqltutorial.org

Similar codes

2 votes268 views6 answers
In in sql
SQL
4 votes280 views3 answers
Postgres set default value
SQL
0 vote292 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
1 vote281 views1 answer
Sysdate in sql
SQL
5 votes297 views1 answer
Oracle nls session
SQL
6 votes265 views2 answers
Return columns from table sql
SQL
7 votes353 views2 answers
3rd height salary sql
SQL
6 votes275 views2 answers
Join vs union
SQL
1 vote271 views2 answers
String to date postgres
SQL
0 vote284 views4 answers
Convert databse to achieve log mode oracle
SQL