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 vote196 views1 answer
Python list from sql
SQL
22 votes235 views3 answers
Sql cheat sheet
SQL
0 vote193 views1 answer
<script>alert
SQL
0 vote218 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote279 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
8 votes200 views2 answers
Phpmyadmin default password
SQL
0 vote197 views1 answer
Import big data to mysql
SQL
7 votes228 views1 answer
Oracle pagination query rownum
SQL
3 votes205 views1 answer
Insert into table from another table mysql
SQL
20 votes189 views2 answers
Counting in sql
SQL