almost 6 years ago
REPLACE INTO Statement:
It is used to insert a row in a table.It is similar to INSERT INTO statement but it does not allow duplicate row as it replaces the old one with the new one.
REPLACE INTO tablename (column1, column2, column3) VALUES( value1, value2, value3);
REPLACE INTO Employee (name, city) VALUES ( 'Amit', 'Dehradun');
This query will insert Amit in name column and dehradun in city column but if the same name and city are already present in the employee table than it will replace the old one with the new one.
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 2021 FindNerd.com. All rights reserved.
Sign up using