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 vote142 views1 answer
Mysql procedure between two tables
SQL
16 votes136 views2 answers
Gremove folder from git
SQL
0 vote148 views1 answer
Oracle sql add column auto generated value
SQL
0 vote144 views1 answer
Cannot pip install mysqlclient
SQL
1 vote134 views2 answers
Sql for date greater than
SQL
1 vote139 views3 answers
What is union in sql
SQL
0 vote150 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote137 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
2 votes145 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote137 views1 answer
Exec procedure oracle
SQL