MySQL Date field , how to assign current date as default value ?

[raminaa niilian]

Hi
Thank you for reading my post
i want to ask how i can assign current date as a default value of a filed when i create the table ?
i am using mysql.

thanks

[karthikeyan Chockalingam]

Hope this helps you

 create table tmp (id int,created_dt timestamp default current_timestamp);   

You may use insert stmt like

  insert into tmp(id) values (123);  

and
created_dt column is assigned the current date time ...Is it what you want?