Adding timestamp column

[Blostre]

Hello there,
I am adding a timestamp column to an existing table with existing records, and all of the timestamp values are 0000-00-00 00:00:00. I wana know how can I get these values to default to the current system time?
Thanks. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[sierra]

Try to update your table SET timestamp=now(); -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --