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 vote105 views1 answer
Check if due date is less than todays date sql
SQL
0 vote129 views3 answers
Sql count condition
SQL
3 votes159 views2 answers
How to delete git repo locally
SQL
0 vote140 views1 answer
Reading from right to left from string find first special characters in sql
SQL
5 votes168 views1 answer
How to get all table names in sql query
SQL
7 votes153 views1 answer
Oracle reset sequence
SQL
-1 vote139 views1 answer
Pl/sql how to delete a trigger
SQL
3 votes144 views2 answers
How to load files in mysql
SQL
7 votes140 views4 answers
Lowest salary in sql
SQL
2 votes146 views2 answers
Select list is not in group by clause
SQL