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 vote294 views1 answer
Get only one row in mysql
SQL
0 vote260 views1 answer
Replace \n sql
SQL
23 votes261 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote267 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote311 views1 answer
Virtuoso sql query tutorial
SQL
1 vote277 views1 answer
Get table column names sql ssms
SQL
0 vote277 views1 answer
How to change null display in psql
SQL
0 vote260 views1 answer
List MySQL Table and Index Size
SQL
1 vote270 views1 answer
Pv mysql import
SQL
0 vote303 views1 answer
Add new column in sql with foreign key
SQL