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 vote268 views1 answer
Mariadb LOAD DATA INFILE
SQL
1 vote289 views2 answers
How to check if sql query is correct online
SQL
7 votes306 views1 answer
Oracle alter sequence restart start with
SQL
0 vote301 views1 answer
Sql show table name in result
SQL
0 vote376 views1 answer
Compare strings lexicographically in sql
SQL
0 vote288 views1 answer
When mysql server would not work in xampp
SQL
0 vote296 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote303 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote283 views1 answer
Empty table sqlite
SQL
0 vote244 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL