Horje
MySQL INSERT IGNORE Statement Code Example
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: www.mysqltutorial.org



Sql

Related
xampp mysql version Code Example xampp mysql version Code Example
sql server on mac m1 Code Example sql server on mac m1 Code Example
BigQuery Remove Duplicate Keys From Table Code Example BigQuery Remove Duplicate Keys From Table Code Example
how to relationship query two different tables in MySQL Code Example how to relationship query two different tables in MySQL Code Example
alter table Code Example alter table Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje