dimanche 24 juillet 2016

Importing SQL database Invalid default value for datetime

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