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 vote317 views3 answers
ChAnge TABLE name apex oracle
SQL
1 vote331 views2 answers
Changes not showing on website server odoo
SQL
0 vote339 views1 answer
Frename oracle
SQL
2 votes353 views1 answer
Sql server: select column values as comma separated string
SQL
10 votes335 views5 answers
Between keyword in sql
SQL
2 votes340 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote354 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote338 views2 answers
Search stored procedures by name
SQL
37 votes420 views6 answers
Mysql update
SQL
0 vote326 views1 answer
Oracle list proxy users
SQL