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

2 votes210 views1 answer
Sql get the name of user pc
SQL
6 votes223 views2 answers
Oracle compile trigger
SQL
1 vote192 views1 answer
Psql import backup file for windows
SQL
0 vote217 views1 answer
Postgres docs /copy metacomand
SQL
0 vote189 views1 answer
How to install Firebird
SQL
2 votes203 views1 answer
Import large .sql files into lampp
SQL
4 votes191 views2 answers
Bulk kill mysql processlist
SQL
0 vote190 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
2 votes223 views1 answer
Postgresql transaction
SQL
0 vote174 views2 answers
Add colum in sql
SQL