over 4 years ago
INSERT IGNORE is used for handling duplicacy in a table as it ignores the query if the data is already present in the table and if the data does not exist then new row will be inserted.
INSERT IGNORE INTO tablename (column1,column2, ......, columnN) VALUES( value1, value2,.....,valueN);
INSERT IGNORE INTO Employee (name,city) VALUES( 'Ankur', 'Delhi');
This query will insert the name and city if they are not already present in the table Employee otherwise it will simply ignore the query and no new row will be inserted.
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2020 FindNerd.com. All rights reserved.
Sign up using