Hello All there,
I am looking for defining default value for a DATETIME column in MYSQL. As I read from the online manual, it says that, the defaul values for a column while creating a table, should always be constant, something like NOW() or CURRENT_TIME cannot be given. But is there a way to have the current date/timestamp stored in to the table in the way of defining DEFAULT VALUE everytime a record is inserted to the table.
Thanks for the help in advance.
Regards,
Vijay G