Re: Update each row in a table based on value in column on same row

[Mike Hillyer]

First of all, why create a calculated column? It would be better to do the calculation during a SELECT to ensure that the values are always up-to-date.

In any case, when updating a column based on the value of another column, just do an UPDATE. Say columnB is columnA+5:

UPDATE mytable SET columnB = ColumnA + 5;

And every row is updated.

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: [phone]
Mobile: [phone]
Blog: http://www.openwin.org/mike