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

4 votes337 views3 answers
Create database in mySQL
SQL
0 vote328 views1 answer
Mysql function variable
SQL
1 vote319 views1 answer
Primary key reset in SQL database
SQL
0 vote329 views1 answer
Mysql replication change database name
SQL
11 votes321 views1 answer
How to get ddl for materialized view
SQL
2 votes333 views1 answer
Oracle sql concatenate results into string
SQL
0 vote339 views1 answer
Execut sql python
SQL
0 vote347 views1 answer
Selecting from a view SQL
SQL
1 vote833 views1 answer
Athena query timestamp greater than
SQL
4 votes343 views3 answers
How to describe a table in sqlite3
SQL