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

1 vote204 views2 answers
Restart identity cascade
SQL
0 vote206 views1 answer
Sql server query database space available
SQL
-1 vote213 views1 answer
Search all sql tables for a value
SQL
2 votes261 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
2 votes218 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
4 votes198 views4 answers
Sqlite describe table
SQL
1 vote194 views2 answers
Populate sql table with random data
SQL
0 vote225 views1 answer
Mysql insert into select transaction c#
SQL
1 vote197 views2 answers
Setval max id postgresql sequence
SQL
0 vote251 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL