What is difference between update and replace and insert set and select insert?
Insert: Insert new record in the table
Update: Update existing record available in the table
Replace: Replace will works exactly like INSERT, except that if an old record in the table has the same value as a new record for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted
Insert Set: To insert values into the specific columns, we can use the SET clause instead of the VALUES clause.
INSERT INTO users SET ID=2, FirstName='UserFName2';
Select Insert: Using the SELECT clause in the MySQL INSERT INTO statement allows inserting the record generated by the SELECT statement into the target MySQL table.
Eg: INSERT INTO cusomers SELECT * FROM users;