执行sql数据库提示这个错误,谢谢解答!
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => CREATE TABLE `ecs_activity` ( `activity_id` smallint(5) unsigned NOT NULL auto_increment, `action_code` varchar(80) NOT NULL default '', `name` varchar(120) NOT NULL default '', `start_time` int(10) unsigned NOT NULL default '0', `end_time` int(10) unsigned NOT NULL default '0', `description` varchar(255) NOT NULL default '', PRIMARY KEY (`activity_id`), KEY `action_code` (`action_code`), KEY `start_time` (`start_time`), KEY `end_time` (`end_time`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ) [2] => Array ( [error] => 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 'DEFAULT CHARSET=utf8' at line 12 ) [3] => Array ( [errno] => 1064 ) )
老数据库有问题,我已经备份到本地了! 在执行sql导入新的数据库时,提示以上错误,请高手解答,谢谢咯!
|