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

1 vote321 views1 answer
Hexadec to sql REDSHIFT
SQL
0 vote314 views1 answer
Convert .mdf to .bak
SQL
2 votes331 views1 answer
Oracle list duplicates
SQL
24 votes342 views6 answers
Replace mysql
SQL
0 vote332 views1 answer
Oracle 11g forget password
SQL
93 votes438 views4 answers
Create database postgres
SQL
0 vote325 views1 answer
Why we have to set the password for my sql server
SQL
6 votes302 views1 answer
Allsource oracle
SQL
1 vote320 views1 answer
Copy postgres table from one schema into another
SQL
1 vote253 views1 answer
Ms sql - add one hour to time
SQL