date stamp help

[dennismonsewicz]

Is there a way to record a time stamp and date stamp in a mysql db and have it become static once the row has been created and then if a user updates that particular row have another column change according to when the user changed the information?

[BlueSkyIS]

use 2 timestamp fields, setting one of them to ON UPDATE CURRENT_TIMESTAMP. on insert, set both to NOW(), then the one with ON UPDATE will automatically update whenever the record is updated.

[dennismonsewicz]

can you give me an example using the now() function?

[BlueSkyIS]

UPDATE some_table SET some_date_field = NOW()

[dennismonsewicz]

ah gotcha, I will give that a try, thanks

[dennismonsewicz]

i am using php myadmin to create a datetime field and when i tell it to on update current_timestamp and I am receiving an error:

 

#1294 - Invalid ON UPDATE clause for 'update_date' column

[dennismonsewicz]

problem solved you have to place the current timestamp on_update field first