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 vote134 views1 answer
How to save data in database in mysql node
SQL
7 votes132 views3 answers
Postgre describe table
SQL
0 vote135 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote170 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote138 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote130 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
3 votes138 views1 answer
Oracle user privileges
SQL
10 votes125 views1 answer
Create table oracle
SQL
0 vote128 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote139 views1 answer
Mysql type for large numbers with many decimal
SQL