标题: 执行sql数据库提示这个错误,谢谢解答!
c1192943
EC新手
Rank: 1



UID 19301
精华 0
积分 23
帖子 16
体力 5 点
钻石 0 颗
贡献 0
阅读权限 10
注册 2007-10-26
状态 离线
发表于 2007-10-30 21:34  资料  个人空间  短消息  加为好友 
执行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导入新的数据库时,提示以上错误,请高手解答,谢谢咯!

顶部
 



当前时区 GMT+8, 现在时间是 2008-7-9 14:01

    本论坛支付平台由支付宝提供
携手打造安全诚信的交易社区 Powered by Discuz! 5.5.0  © 2001-2007 Comsenz Inc.
Processed in 0.031517 second(s), 6 queries , Gzip enabled

清除 Cookies - 联系我们 - 康盛创想(北京)科技有限公司 - Archiver - WAP