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

5 votes206 views2 answers
Oracle timestamp to date
SQL
-1 vote201 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote249 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
1 vote193 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
1 vote229 views1 answer
Mysql previous year
SQL
2 votes203 views1 answer
Pdo mysql insert
SQL
0 vote212 views1 answer
Select * from mysql.proc
SQL
0 vote186 views1 answer
Where case insensitive like mysql
SQL
0 vote204 views2 answers
Mysql multiply
SQL
4 votes198 views2 answers
Mysql select where starts with
SQL