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
How do I insert a blob in SQL?
SQL
0 vote115 views1 answer
Dbms_output sql developer
SQL
33 votes109 views2 answers
Postgres how to add field created at
SQL
1 vote116 views1 answer
Last 6 months postgresql
SQL
3 votes119 views1 answer
Locate sql server
SQL
0 vote131 views1 answer
Check database restore status sql script
SQL
3 votes126 views2 answers
Enter mysql command line
SQL
0 vote112 views1 answer
Postgresql alter column nullable
SQL
5 votes141 views3 answers
Show indexes mysql
SQL
0 vote121 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL