Mysql timestamp与datetime区别

创建表

create table t8 (
  `id1` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `id2` datetime default NULL
);

查看表结构

desc t8;

[img]http://www.iteye.com/upload/attachment/64980/d9179e72-2b68-32de-bd6c-186ed2d772be.gif[/img]
查看时区变量

show variables like 'time_zone';

[img]http://www.iteye.com/upload/attachment/64976/f7e91327-e785-3ebb-96cb-481509676d97.gif[/img]
插入值并查看

insert into t8 values(now(), now());
select * from t8;

[img]http://www.iteye.com/upload/attachment/64974/4e21fd8f-3e17-3a11-9345-0810c6317404.gif[/img]
修改时区并查看

set time_zone='+9:00';
select * from t8;

[img]http://www.iteye.com/upload/attachment/64982/24ace695-5229-3709-9934-196e4a96ffaa.gif[/img]