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

1 vote103 views2 answers
Mysql join two tables
SQL
0 vote102 views1 answer
Oracle job class
SQL
0 vote159 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote100 views3 answers
Group_concat sql server
SQL
0 vote145 views1 answer
Postgres extract number from string
SQL
14 votes102 views5 answers
Set password for postgres user ubuntu
SQL
0 vote102 views1 answer
Transaction and commit trong sql server
SQL
0 vote133 views1 answer
SQL Where-Klausel
SQL
2 votes95 views1 answer
Oracle sql concatenate results into string
SQL
2 votes94 views2 answers
Join update query in sql
SQL