Difference between Insert, Update and Modify

Updated May 18, 2018

INSERT - Add a new record into the database table.

MODIFY - If record is available it modifies otherwise it wont modify.

UPDATE - If record is available its update the record otherwise it creates a new record.

Insert-used to insert the records Modify-used for alter the table field names Update-used for modify the data

Insert:Insert a set of new data's into database table.,

Update:Chance the existing data field in data base table.,

Modify:If the record is present then you how to Update the data's otherwise,Insert the new data.,

Comments

16 Nov 2017 3:14 pm Sonia Barwar Helpful Answer

Whenever you need to create new records in the database table use INSERT. Whenever using INSERT be sure that a duplicate entry having the same values for the primary key fields are not present. Else it may throw a dump.
When you use MODIFY it makes a check for the matching key field values. If present it modifies the matching record, else it creates a new record in the database table.

13 Jun 2008 3:55 am Guest
If Update does the work of modify then what is the need of modify to use. Can u plz explain.