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 vote349 views2 answers
Transaction php
SQL
0 vote353 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote374 views1 answer
Check if string is a number sql
SQL
12 votes344 views2 answers
Delete all nodes neo4j
SQL
23 votes361 views2 answers
Query to delete a database in mysql
SQL
0 vote345 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote357 views2 answers
PostgreSQL having
SQL
0 vote337 views1 answer
Raiserror nowait sql server
SQL
1 vote337 views1 answer
How to select department from table
SQL
1 vote355 views1 answer
Mysql dump specific tables
SQL