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

);