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

35 votes132 views5 answers
Sql alter column
SQL
2 votes112 views1 answer
Oracle table size
SQL
0 vote126 views1 answer
Mysql show create db
SQL
14 votes126 views3 answers
Alter foreign key
SQL
3 votes76 views1 answer
How to get list of synonyms in oracle
SQL
6 votes82 views2 answers
Generate c# class from sql server table
SQL
0 vote113 views1 answer
Sql case when exists in another table
SQL
0 vote124 views1 answer
Alter owner in PostgreSQL
SQL
0 vote129 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote120 views2 answers
Get all index postgres
SQL