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 vote218 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
6 votes280 views2 answers
How to get last element sql
SQL
0 vote243 views1 answer
Express api ith mysql data
SQL
1 vote191 views2 answers
Show sql logs in spring boot
SQL
0 vote251 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
2 votes234 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote249 views3 answers
Postgres date difference seconds
SQL
4 votes243 views6 answers
Sql select statement
SQL
7 votes248 views1 answer
Oracle pagination query rownum
SQL
0 vote265 views1 answer
Alternative for LIMIT sql
SQL