In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Jason Stechschulte) 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.
To be more precise: the *first* timestamp field in a table always updates
itself whenever the row is updated.
> You could simply change the column
> type to datetime.
Yep. Or add another timestamp column before t_stamp. But unless you have
use for this auto-updating value (and it doesn't sound like you do), the
first suggestion is the better one.
--
CC
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]