创建MYSQL表时的日期时间和时间戳问题

Question

I am trying to create mysql table in PhpMyAdmin in Hostgator server with the following information but it is showing error

Error : #1067 - Invalid default value for 'CreatedDate'

Table

  CREATE TABLE `tbl_sample` (
  `ID` int(11) NOT NULL  AUTO_INCREMENT,
  `Domain` varchar(100) DEFAULT NULL,
  `ClickUrl` varchar(600) DEFAULT NULL,
  `CreatedDate` datetime NULL DEFAULT now(),
  `ModifyDate` timestamp NULL DEFAULT NULL on update now(),
  PRIMARY KEY (`ID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

The purpose of table is I need to enter only 'Domain' and 'ClickUrl' data using insert command remaining Id(autoincrement),CreatedDate(current date when inserting row),ModifyDate(when update the row) will automatically insert.

The above table is executed successfully in mysql environment in my local system but it is not executing in the mysql environment in hostgator

Answer 1

Check this link]1

Problem with creating Two column with timestamps. have to use trigger to get it done.