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 vote135 views1 answer
How much table store postgres
SQL
11 votes151 views1 answer
Oracle export view ddl
SQL
7 votes135 views3 answers
Postgre describe table
SQL
2 votes121 views1 answer
Create table with primary key
SQL
5 votes158 views3 answers
Show indexes mysql
SQL
1 vote137 views1 answer
Sql server list locks
SQL
0 vote132 views1 answer
Get null value in sql
SQL
0 vote137 views1 answer
Postgres sql alter table delete row
SQL
1 vote121 views1 answer
Set id count mysql
SQL
0 vote138 views1 answer
Sql auto_increment syntax
SQL