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 vote200 views1 answer
Select odd records sql
SQL
0 vote207 views1 answer
Grant owner postgresql
SQL
0 vote206 views1 answer
Mysqli last row
SQL
0 vote220 views4 answers
Convert databse to achieve log mode oracle
SQL
1 vote231 views1 answer
Postgresql update auto_increment value
SQL
0 vote186 views1 answer
Access refused mysql xampp server
SQL
1 vote219 views3 answers
Psql fatal database does not exist
SQL
0 vote193 views2 answers
Disallowed function mysql to_date()
SQL
1 vote265 views1 answer
Base64 encode sql server
SQL
0 vote208 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL