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

9 votes220 views3 answers
Mysql run sql file
SQL
28 votes157 views6 answers
Distinct sql
SQL
7 votes189 views1 answer
Append column sql
SQL
7 votes167 views1 answer
Mysql load data infile csv
SQL
3 votes251 views1 answer
Dbms_scheduler drop_job
SQL
0 vote199 views1 answer
Sql recherche nom prenom
SQL
1 vote217 views1 answer
Delete dublicate rows sql
SQL
2 votes213 views1 answer
How to show the whole table in sql
SQL
0 vote270 views1 answer
Mysql row generator
SQL
0 vote264 views1 answer
Order by number of character in sql
SQL