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

4 votes272 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote310 views1 answer
Sqlite get date only
SQL
0 vote272 views1 answer
Downgrading sql localdb visual studio
SQL
2 votes289 views1 answer
Plsql block
SQL
1 vote302 views3 answers
SELECT * FROM
SQL
1 vote310 views1 answer
Random name function in mysql for nvarchar
SQL
1 vote293 views2 answers
Mssql show database size
SQL
0 vote277 views1 answer
Stuff in sql server
SQL
0 vote277 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
10 votes308 views4 answers
Drop primary key
SQL