I'd suggest not using the keyword "timestamp" as a column name. I'd suggest using "ts" or "tstamp" or something like that.
To update the records to the current timestamp....: update try set tstamp=null; should do it. I don't know why the default isn't working, though. On Mon, 28 Feb 2005 10:05:32 -0500, Zhe Wang <[EMAIL PROTECTED]> wrote: > Hi, there, > > I have MySQL 4.1.10. I need to add a timestamp column to an existing > table. I am having a problem of setting the newly added column to be the > current time. > > This is what I did: > > CREATE TABLE try (id INTEGER); INSERT INTO try VALUES(1), (2), (3); > > ALTER TABLE try ADD timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP; > > SELECT * FROM try; > > +------+---------------------+ > > | id | timestamp | > > +------+---------------------+ > > | 1 | 0000-00-00 00:00:00 | > > | 2 | 0000-00-00 00:00:00 | > > | 3 | 0000-00-00 00:00:00 | > > +------+---------------------+ > > I've read the on-line manual regarding the change in timestamp, still > couldn't figure out why 0's got inserted instead of a meaningful current > time stamp. I would greatly appreciate if someone can let me know what > the correct way is. Unfortunately I cannot recreate the table. > > Thank you very much! > > Regards, > Zhe > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- -Hank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]