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 vote178 views1 answer
Tsql delete all rows
SQL
0 vote174 views1 answer
Mysql group rows with same value
SQL
0 vote188 views1 answer
On update current_timestamp jpa
SQL
7 votes186 views5 answers
Show details of table postgres
SQL
0 vote244 views1 answer
Create table as select sql server error
SQL
0 vote233 views1 answer
Sql min
SQL
0 vote199 views1 answer
Postgresql function ROUND
SQL
2 votes178 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote237 views1 answer
Mysql show foreign keys column
SQL
1 vote186 views1 answer
Mariadb case switch
SQL