Re: Error 1175 - I an trying to update a column in every record

[Chad Ramos]

laptop alias Wrote:
-------------------------------------------------------
> Why would you want to store the age of the
> customer? Just calculate it on the fly!


Well, there are further demographic calculations I will be doing on the ages. With a large data set it would seem that an processing hit would end up being negative when calculating ages multiple times in one query.

None the less, I still would love to know if there is a way to do what I did with out turning safe updates off and on.

Thanks for the relpy,

Chad