Timestamp MYSQL question

[mysqlUser1986]

I have a large database with close to 1 million records. I recently added a timestamp field to one of my tables so I would be able to track when updates were made on each of these records. The only problem I am having is that when I added this field, the timestamp showed the same exact time for every record. Is there anyway to make all of these fields unique, so the time is different in all of them. I am concerned with getting my older records to all have different times in this timestamp field. It is type timestamp(14)

Thanks for you help
Steve

 

[sleipnir214]

timestamp is updated when a record is changed or inserted. When you added the timestamp column, you updated all the rows at once, so having the same value in all rows is correct behavior.

You can explicitly change the value of a timestamp field to an arbitrary value. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!