Re: mysql timestamp field

On Thu, Sep 06, 2001 at 05:09:43PM +0300, Mesut Tunga wrote: > I need an update on my table. but I have a timestamp field called > t_stamp. When I update a field other than t_stamp field, t_stamp field > also updates to now(). I need it not to update and saves its value. > > How should I do this? The easiest way is to change the column type. Timestamp always updates itself whenever the row is updated. You could simply change the column type to datetime. -- Jason Stechschulte jpstech@unoh.edu -- The reason I like hitching a ride on strict vars is that it cuts down the number of rarely used pragmas people have to remember, yet provides a way to get to the point where we might, just maybe, someday, make local lexicals the default for everyone, without having useless pragmas wandering around various programs, or using up another bit in $^H. -- Larry Wall in <199710050130.SAA04762@wall.org>