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 vote436 views1 answer
Compress sql file database ubuntu
SQL
1 vote356 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote354 views1 answer
Sql developer connect to sql server
SQL
37 votes443 views6 answers
Mysql update
SQL
6 votes360 views2 answers
Postgresql pg_dump
SQL
0 vote374 views1 answer
Oracle to_number
SQL
1 vote352 views2 answers
Sql server add time to date
SQL
2 votes377 views2 answers
Calculate percentage in sql
SQL
8 votes454 views3 answers
Find table for column name in sql
SQL
0 vote344 views1 answer
Sqlalchemy query join many to many
SQL