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

2 votes181 views1 answer
Sql ends with string
SQL
0 vote174 views1 answer
Mysqldump don't drop table
SQL
3 votes181 views2 answers
How to start mysql in terminal
SQL
0 vote154 views1 answer
Alter session set nls_language french
SQL
3 votes212 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote183 views1 answer
Grant privileges mysql to database 1064
SQL
1 vote169 views1 answer
Using SQL in rails migration
SQL
0 vote173 views1 answer
Sql get table last modified time
SQL
0 vote170 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote191 views1 answer
Mysql set variable to today's date
SQL