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 vote320 views5 answers
Left join sql
SQL
2 votes245 views2 answers
Insert all in sql
SQL
2 votes253 views1 answer
Oracle create directory
SQL
1 vote244 views1 answer
SQLSTATE[HY000] [2002]
SQL
7 votes223 views1 answer
Alter table add key sql
SQL
1 vote267 views1 answer
How to find median of a column sql
SQL
0 vote304 views1 answer
Creating sqeuence in oracle database
SQL
0 vote283 views1 answer
Manage Database in MySQL
SQL
1 vote236 views2 answers
Procedure pl/sql
SQL
7 votes319 views3 answers
Sql server check if temp table exists
SQL