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 vote167 views1 answer
Update set with inner join oracle
SQL
34 votes203 views6 answers
Sql change data type
SQL
1 vote237 views1 answer
Backup mysql schema only
SQL
4 votes174 views1 answer
Restart for pg_hba.conf file
SQL
0 vote131 views1 answer
Delete all rows from table sqlite
SQL
1 vote183 views1 answer
Query for all indexes in table postgres
SQL
1 vote173 views1 answer
Search for replace in mysql
SQL
0 vote248 views1 answer
Sqlite display headers on columns
SQL
4 votes265 views1 answer
Select first and last row sql
SQL
20 votes163 views5 answers
Sql show tables
SQL