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 vote147 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote131 views1 answer
Postgresql delete limit
SQL
0 vote136 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote163 views3 answers
Characters found after end of sql statement
SQL
0 vote136 views1 answer
Update sqlite
SQL
0 vote118 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote131 views1 answer
Drop procedure sql
SQL
0 vote142 views1 answer
Mysql root localhost run
SQL
0 vote147 views1 answer
Postgres change the name of schema
SQL
1 vote125 views2 answers
How to enable error squiggles in vs code
SQL