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 vote140 views1 answer
Search mysql database for column
SQL
20 votes150 views4 answers
Reset auto increment in MySQL
SQL
-1 vote137 views1 answer
How to check table exists or not in postgresql
SQL
0 vote131 views1 answer
Sql count more than 1
SQL
0 vote145 views1 answer
Grant owner postgresql
SQL
8 votes131 views1 answer
Unique vs primary key
SQL
0 vote158 views1 answer
Repeatable read trong sql server
SQL
8 votes103 views1 answer
Oracle current date plus 1 month
SQL
0 vote145 views1 answer
Sp in sql server
SQL
1 vote164 views1 answer
Mysql previous year
SQL