How to change the value of a particular row

hibuddies · New User Joined: 06 Feb 2007 Posts: 20 Location: Bangalore

Hi all,

How to change the value of a single or a particular row using UPDATE keyword without using WHERE clause.

Thanks in advance.

dick scherrer · Posted: Thu Mar 29, 2007 3:38 am

Hello,

Your request is not at all clear. If you do not use a WHERE, how will you have the "particular row" available to update?

Please post some data, how you want it acted upon, and how you would think to isolate the one row you want to modify.

vini_srcna · Posted: Thu Mar 29, 2007 1:54 pm

This questions makes absolutely no sense to me.

The only solution i could think of is:

Keep only that particular row in the table and issue an update statement

Updates tries to update all the rows. Since you have only that particular row in the table it will get updated