mysql默认值无效_MySQL：TIMESTAMP的默认值无效

我收到了错误

ERROR 1067 (42000) at line 5459: Invalid default value for 'start_time'

运行以下查询时

DROP TABLE IF EXISTS `slow_log`;

CREATE TABLE IF NOT EXISTS `slow_log` (

`start_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

`user_host` mediumtext NOT NULL,

`query_time` time(6) NOT NULL,

`lock_time` time(6) NOT NULL,

`rows_sent` int(11) NOT NULL,

`rows_examined` int(11) NOT NULL,

`db` varchar(512) NOT NULL,

`last_insert_id` int(11) NOT NULL,

`insert_id` int(11) NOT NULL,

`server_id` int(10) unsigned NOT NULL,

`sql_text` mediumtext NOT NULL

) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log';

我正在使用MySQL 5.7.18

$mysql --version

mysql Ver 14.14 Distrib 5.7.18, for osx10.10 (x86_64) using EditLine wrapper

CREATE TABLE t1 (

ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

);

上面的SQL语法有什么问题？