difference update and insert

[Former Member]

what is the difference between update and insert in the case of database tables? what does update do and what does insert do?

[Former Member]

INSERT is to add a new record to database.

UPDATE is to modify a field value of an existing record in database.

[Former Member]

HI ,

in the name itself meaning is there

1. Insert is for inserting new row into Database table .

2. Update is for changing the existing row in Database Table.

THX

[Former Member]

Hi

Insert is to insert a new row into the database table

whers as update is to change the exsting row in the database table

plzz reward if usefull

feel free to ask any quiries my mail id is mutyalasunilkumar@gmail.com

[Former Member]

hi,

insert ... will only insert a new record ...

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/insert_d.htm

update : will only update the existing record...

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/update.htm

Hope this is helpful, Do reward.

[Nimesh_S_Patel]

Hi,

Insert Functionality,

Inserts new lines in a database table.By default, data is only inserted in the current client. Data can only be inserted using a view if the view refers to a single table and was defined in the ABAP Dictionary with the maintenance status "No restriction".

Update Functionality,

Updates values in a database table. Normally, lines are updated only in the current client.

INSERT & UPDATE belongs to the Open SQL command set.

Thanks

Nimesh S. Patel

[abdul_hakim]

Hi,

INSERT- to insert the data record.

UPDATE - to update the existing data record

Cheers,

Hakim