Why we use IGNORE keyword query in MySQL?
There are certain condition when we need to insert some duplicate records in table in presence of unique index. But when we try this we will get some error. So to discard this we use the "INSERT IGNORE" command instead of "INSERT". And MSSQL will discard the record if it is duplicate. And below is the syntax for IGNORE Keyword in MySQL:-
INSERT IGNORE INTO Table (field1, field2, field3)
-> VALUES( 'value1', 'value2', 'value3'); | |