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

3 votes207 views3 answers
Remove all spaces from string sql
SQL
0 vote218 views3 answers
Average salary in sql
SQL
0 vote215 views1 answer
Mysql wsrep ls
SQL
-1 vote213 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
1 vote356 views3 answers
Sql subquery
SQL
1 vote209 views1 answer
Oracle index partition
SQL
0 vote226 views2 answers
Sqlalchemy core in clause
SQL
1 vote241 views1 answer
Postgres see sequence current state
SQL
35 votes221 views6 answers
Postgres
SQL
2 votes236 views2 answers
Create table mysql integer NOT null
SQL