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 vote313 views1 answer
Postgresql get diff between two dates in Months
SQL
1 vote298 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote327 views1 answer
Mysql disable triggers
SQL
1 vote301 views1 answer
Raw query must include primary key
SQL
6 votes309 views1 answer
Sql insert values into table
SQL
0 vote350 views1 answer
Array aggre distinct postgres
SQL
1 vote302 views1 answer
Oracle add proxy
SQL
0 vote290 views1 answer
Mysql select where text contains
SQL
1 vote299 views1 answer
Can not connect to mysql server
SQL
1 vote310 views1 answer
Mysql select all and rename one
SQL