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 vote212 views1 answer
Oracle lower in where clause
SQL
0 vote203 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote213 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
0 vote231 views1 answer
Sql tablo hangi sp de
SQL
0 vote280 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
6 votes195 views5 answers
Mysql get last insert id
SQL
11 votes221 views3 answers
Sql line numbers
SQL
10 votes208 views2 answers
Forgot my mysql password mac
SQL
0 vote216 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote192 views1 answer
Eliminar ultimo carcacter mysql
SQL