Results 1 to 7 of 7
Aug 21, 2012, 11:06 #1
- Join Date
- Dec 2007
- 0 Post(s)
- 0 Thread(s)
Storing numerical data as a timestamp?
I'm trying to figure out how to properly configure my mysql database to store numbers as a timestamp. I don't believe this is the correct way to do so. I tried changing the TYPE to VARCHAR but I get a mysql error. The below URL is where I want my user to input information.
TYPE | timestamp
Default | CURRENT_TIMESTAMP
Attributes | ON UPDATE CURRENT_TIMESTAM
This is what I'm trying to do.
At the below URL their are two users. They each have a favorite number.
hockeyman = 2
coolguy = 3
If hockeyman changes his number to 8
coolguy changes his number is 12
Using a timestamp what's the best way to store the old numbers of 2/3? while keeping the new numbers of 8/12.