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

92 votes326 views6 answers
Substring
SQL
48 votes194 views3 answers
Psql create database
SQL
3 votes207 views1 answer
Postgres count distinct
SQL
4 votes181 views1 answer
Mac install mysql
SQL
0 vote203 views1 answer
Codeigniter 3 get best-selling products
SQL
1 vote207 views3 answers
Update from select sqlite
SQL
1 vote201 views3 answers
Union in sql
SQL
2 votes195 views3 answers
Postgresql reset auto increment
SQL
0 vote188 views1 answer
Sql server delete records with specific date
SQL
0 vote198 views1 answer
Sql cnvert bit to nvarchar
SQL