SQL Query to change/alter rows

Is there any sql query to change/alter all the rows values at once

otherwise I ll have to edit each row individually

 

It's not clear for me what you mean but check alter table and update syntax
Regards

 

Thnx anyways

 

Please specify how update must be performed and I'll try to help.

Regards

 

Of course in SQL you can update all rows by one query ... use UPDATE (more info. http://en.wikipedia.org/wiki/Update_(SQL))

 

yep ofcourse. just make sure your condition is sufficient.

 

Thanks all of you