topic Re: UPDATE without WHERE Clause in Application Development and Automation Discussions

UPDATE without WHERE Clause

Former Member — Tue, 29 Aug 2006 12:59:55 GMT

What will happen if we use Update statement without WHERE clause?

Thanks

Former Member — Tue, 29 Aug 2006 13:03:31 GMT

It will update all the records of the particular table..when it is used as follows..

UPDATE ztable SET f1 = 'test'.

If you are using within select-endselect loop it just updates one record.

Regards

Anurag

Message was edited by: Anurag Bankley

Former Member — Tue, 29 Aug 2006 13:04:32 GMT

hi,

The statement UPDATE changes the content of one or more lines of the database table if no where condition is specified.

Regards,

Sailaja.

andreas_mann3 — Tue, 29 Aug 2006 13:06:09 GMT

hi,

1) UPDATE dbtab SET f1 ... fn.  -> <b>all values are changed</b>
2) UPDATE dbtab.       -> <b>only 1</b> item is changed

Message was edited by: Andreas Mann

Former Member — Tue, 29 Aug 2006 13:13:51 GMT

HI,

Update without where caluse updates all the

rows with the values specified in set.

update ztable set matnr = '100'.

update ztable with matnr 100 for all rows.

Regards,

Amole