regarding update and modify

[Former Member]

good evening.

what is the difference between update keyword and modify keyword.

thanks and regards,

k.swaminath reddy.

[Former Member]

Hi

basicly

UPDATE - updates existing table rows

MODIFY - updates existing rows but also APPENDS new one's which you want to append if they don't exist already,if they exist - this command changes them.

Regards

Yossi

[Former Member]

Hi swaminath,

1. UPDATE = it will only update the record in database table.

if the record is NOT FOUND, based upon the primary key,

then it will give error.

2. MODIFY = If record is found (based upon the primary key)

It will update/modify the record,

OTHERWISE

It will automatically insert a new record.

regards,

amit m.

[Former Member]

Hi,

Update you can change database primary key value which is not

possible with modify.

modify updates database when record exist else inserts new record

and also used in internal table operations.

update modified database table only when entry exist.

while using update clause use where condition else it updates all records

of table.

regards

ravish

<b>plz dont forget to reward points if useful</b>