Register Login

Difference between Insert, Update and Modify

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

  • 15 Feb 2010 8:02 am Guest Helpful Answer
    INSERT - Add a new record into the database table.
    UPDATE - If record is available it modifies it.
    MODIFY - If record is available it updates the record otherwise it creates a new record.

    This means MODIFY can do the job for both UPDATE as well as INSERT.

    -Rudresh
  • 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.
  • 04 Sep 2008 3:26 am Guest
    Update WON'T add new record(s), but modify will.

×