IGNORE keyword in MySQL

on simple definition IGNORE suppresses errors, errors are treated as warnings, while executing the INSERT Query, when INSERT IGNORE is used.
without IGNORE, a row that duplicates an existing UNIQUE index or PRIMARY KEY value in the table causes a duplicate-key error and the statement is aborted. With IGNORE, the row still is not inserted, but no error is issued.
when INSERT IGNORE is used, the insert operation fails silently for the row containing the unmatched value, but any rows that are matched are inserted.
The Query can be written as
$sql = ” INSERT IGNORE INTO tbl (id, col1) values (”,$val1)”;


Popular posts from this blog

111 Most Useful Websites on the Internet

How to call php functions inside smarty template directly

How to improve PHP web performance