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 votes155 views3 answers
Stop mysql service ubuntu
SQL
1 vote150 views1 answer
Not exists mysql
SQL
37 votes190 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote153 views1 answer
Max mysql
SQL
0 vote148 views1 answer
Create schema sql server
SQL
13 votes171 views1 answer
Sql join 3 tables on id
SQL
0 vote174 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
1 vote196 views3 answers
Date_add mysql
SQL
1 vote149 views6 answers
In sql
SQL
2 votes157 views4 answers
How to find 2nd highest salary in mysql
SQL