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 vote144 views1 answer
Nueva tabla mysql
SQL
2 votes156 views2 answers
Insert all in sql
SQL
6 votes146 views1 answer
What is where clause in sql
SQL
0 vote258 views1 answer
Multiple replace value mssql
SQL
1 vote113 views1 answer
Unique vs distinct sql
SQL
0 vote155 views1 answer
Count characters of string mysql
SQL
0 vote140 views1 answer
Learn sqlite dart
SQL
0 vote156 views4 answers
Best data type to represent money in mysql
SQL
16 votes170 views5 answers
Select last row in sql
SQL
0 vote159 views1 answer
Duplicate value unique constraint mysql error
SQL