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

0 vote183 views2 answers
Reseed sql identity
SQL
11 votes162 views1 answer
Get ddl materialized view oracle
SQL
1 vote154 views1 answer
PLS-00225 type
SQL
0 vote173 views1 answer
Mssql disable foreign key constraint
SQL
0 vote187 views1 answer
Download sql file of countries names
SQL
1 vote166 views1 answer
Primary key with prefix sql
SQL
0 vote178 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
5 votes240 views4 answers
Sql check
SQL
0 vote170 views1 answer
How to connect to mysql in ef 6
SQL
-2 votes182 views1 answer
No module named '_sqlite3
SQL