1.timestamp类型
create table manager(
id int not null primary key,
mdate timestamp not null default current_timestamp
);
2.datetime类型
create table manager(
id int not null primary key,
mdate datetime
);
原文：http://www.cnblogs.com/371610785qq/p/7670245.html