MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


5.6.51


create table t1 (
id int not null,
d1 timestamp) 
engine=innodb;
show create table t1;


Table
Create Table


t1
CREATE TABLE `t1` (
  `id` int(11) NOT NULL,
  `d1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1


create table t2 (
id int not null,
d1 timestamp,
d2 timestamp) 
engine=innodb;
show create table t2;


Table
Create Table


t2
CREATE TABLE `t2` (
  `id` int(11) NOT NULL,
  `d1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `d2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1