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 vote207 views1 answer
Running percentage of total postgres
SQL
0 vote173 views1 answer
Complete date is 1 year or not sql server
SQL
1 vote179 views4 answers
Psql check tables command
SQL
0 vote177 views1 answer
What are the aggregate function in sql
SQL
0 vote185 views1 answer
Group by two columns postgres
SQL
0 vote182 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
14 votes198 views1 answer
Oracle new column
SQL
7 votes216 views1 answer
Mysql unsafe update
SQL
0 vote183 views1 answer
Pgsql is not permitted to log in
SQL
0 vote174 views1 answer
Get sum sqlite android
SQL