CREATE TABLE `test_olo_newsletter` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mail` varchar(50) NOT NULL DEFAULT '', `host` varchar(200) NOT NULL DEFAULT '', `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=10 ;
MySQL zwrócił komunikat: Dokumentacja
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY
Pewno dla was to pikuś ja szukałem w manualu ale nie dopatrzyłem sie błędu
Export był robiony w wersji 4.x.x.x a ja importuje do 5.x.x.x
CREATE TABLE `test_bip_newsletter` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT , `mail` varchar( 50 ) NOT NULL DEFAULT '', `host` varchar( 200 ) NOT NULL DEFAULT '', `insert_time` timestamp NOT NULL DEFAULT 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP’ , PRIMARY KEY ( `id` ) , UNIQUE KEY `id` ( `id` ) ) TYPE = MYISAM AUTO_INCREMENT =10;
Brakowało po default ' ......'