I am moving a database from one MySQL server to another, however when importing one table I end up with the error:
1067 - Invalid default value for 'date'
the table SQL:
CREATE TABLE IF NOT EXISTS `log` (
`id` int(11) NOT NULL,
`date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`url` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8
Importing to MySQL version 5.5.47 from 5.6.21
Aucun commentaire:
Enregistrer un commentaire