Hi,

I couldn't use current_date as default value for a date datatype column in mysql.
How can I acheive this in 'CREATE' statement in mysql.

Thanks,
Sam

you can use a timestamp, but unfortunately it will get updated every time the row is updated

otherwise, no, you cannot declare a function as a default value in mysql

you could do something like this:
CREATE TABLE X (
last_changed timestamp,
create_time timestamp,
.....);
If you have two columns of type timestamp, only the first one will change on each update. The other one will settle on the date the row was created and stay unchanged.
Hope I've explained that clear.

nice idea, but how, exactly, does the second one get its initial value?

hmm. unfortunately I'm not sure its possible to be done by default but rather with the insert statement (when the row is first inserted). Sorry.