timestamp

CloudedVision · Feb 27th, 2008, 00:52

i have a table with two timestamp columns: created_at and updated_at

when I update a value in the table and set updated_at to the time, created_at updates itself too!

why?

able · Feb 27th, 2008, 03:51

This changed a bit between versions but my understanding is that by default, the first timestamp column in the table will auto update, the rest will not.

You can either just switch the columns or specify for the default behaviours to be changed with an alter table.