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 vote176 views1 answer
Excel vba import data to sql server
SQL
0 vote161 views1 answer
Dump only schema
SQL
0 vote169 views1 answer
If column value is null then in mysql
SQL
0 vote163 views1 answer
Mysql_union
SQL
1 vote175 views1 answer
Events mysql
SQL
2 votes226 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
25 votes178 views6 answers
How to change column name in mysql
SQL
16 votes176 views4 answers
Sort by sql
SQL
1 vote167 views2 answers
Change table name phpmyadmin
SQL
0 vote194 views1 answer
Mysql disable triggers
SQL