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 vote248 views3 answers
Get free card roblox
SQL
1 vote252 views1 answer
Count of tables in database mysql
SQL
32 votes302 views6 answers
Rename column mysql
SQL
0 vote268 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote253 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote299 views2 answers
Sql query print strings and int
SQL
0 vote273 views1 answer
Uncheck constraints and delete from table
SQL
2 votes269 views1 answer
Sqlite3 show columns name
SQL
3 votes252 views3 answers
List columns in table postgres
SQL
0 vote246 views1 answer
Oracle last connection
SQL