I have a datetime data type in one of my tables and i want it to set the current date to itself when a record is inserted into the table. I know i could use the timestamp data type and assign CURRENT_TIMESTAMP as the default, but can this be done with the datetime data type as well?
I already have a field with the timestamp data type, it is used to determine when the record was last updated. I want another record to do basically the same thing except it must only contain when the record was added to the database. I tried using timestamp with its default value but apparantly i can't do that, navicat won't let me assign more than one timestamp field a default value of CURRENT_TIMESTAMP... so i'm turning towards using the datetime data type to get this done, is there a default value i could use to allow the datetime data type to assign the current date and time to itself when a record is added to the table?
Thanks for your help
BTW: I'm using MySQL