mysql时间和日期类型datetime

datetime
– 创建时间日期表
create table my_time(
d1 datetime,
d2 date,
d3 time,
d4 timestamp,
d5 year
)charset utf8;

插入数据
insert into my_time values(
‘2015-09-08 11:50:36’,‘2016-11-11’,‘11:50:50’,‘2015-09-08 11:50:36’,2016
);

insert into my_time values(
‘2015-09-08 11:50:36’,‘2016-11-11’,‘11:50:50’,‘2015-09-08 11:50:36’,59
);
insert into my_time values(
‘2015-09-08 11:50:36’,‘2016-11-11’,‘11:50:50’,‘2015-09-08 11:50:36’,77
);

timestamp只要当前数据被更新，这个字段会更新