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

5 votes363 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote374 views1 answer
Calculate age in sql
SQL
0 vote372 views1 answer
Sql put two columns into one
SQL
2 votes377 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
1 vote376 views1 answer
ORA-01950
SQL
0 vote385 views1 answer
Drop database using terminal postgres
SQL
22 votes350 views3 answers
Sql cheat sheet
SQL
0 vote387 views1 answer
Enable outgoing remote MySQL access
SQL
1 vote363 views2 answers
Sql select only row with the max date
SQL
7 votes386 views1 answer
Query postgres delete duplicates
SQL