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 vote165 views1 answer
Update top 100 order by sql server
SQL
0 vote152 views2 answers
Mysql decimal remove trailing zeros
SQL
1 vote160 views3 answers
Drop unique key constraint in sql server
SQL
19 votes149 views2 answers
Mysql add column after another
SQL
0 vote170 views1 answer
Sql last 3 rows
SQL
3 votes171 views2 answers
Mysql select database
SQL
0 vote200 views1 answer
How to check rollback status in oracle
SQL
6 votes144 views1 answer
Phpmyadmin reset root password
SQL
0 vote165 views1 answer
Mysql config address
SQL
1 vote160 views1 answer
How to select rows with no matching entry in another table?
SQL