用phpcms建的网站,数据库恢复的错误。在好几个空间试的 都是这个错误,到底是什么原因呢?
MySQL Query:CREATE TABLE `wh_admin` ( `userid` int(11) unsigned NOT NULL default '0', `username` varchar(30) NOT NULL default '', `grade` tinyint(2) unsigned NOT NULL default '0', `purviewids` text NOT NULL, `modules` text NOT NULL, `channelids` text NOT NULL, `catids` text NOT NULL, `specialids` text NOT NULL, `disabled` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`userid`), KEY `grade` (`grade`)) ENGINE=MyISAM DEFAULT CHARSET=gbk
MySQL 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=gbk' at line 1
MySQL Errno:1064
Message:MySQL Query Error
希望能解决了!
MySQL Query:CREATE TABLE `wh_admin` ( `userid` int(11) unsigned NOT NULL default '0', `username` varchar(30) NOT NULL default '', `grade` tinyint(2) unsigned NOT NULL default '0', `purviewids` text NOT NULL, `modules` text NOT NULL, `channelids` text NOT NULL, `catids` text NOT NULL, `specialids` text NOT NULL, `disabled` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`userid`), KEY `grade` (`grade`)) ENGINE=MyISAM DEFAULT CHARSET=gbk
MySQL 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=gbk' at line 1
MySQL Errno:1064
Message:MySQL Query Error
希望能解决了!
解决方案 »
- 怎样避免mysql(root)密码不被人更改!
- 急!触发器"stack depth limit exceeded"错误是咋回事啊?
- 请问怎样实现一个最简单的模拟mysql的桩
- vc连接mysql5.0 出现1251错误,Client does not support authentication protocol
- mysql中的库的字段不能自动递增的么,就象ms sql中的identity
- 从两个数据库取出数据,怎么汇总排列??
- 寻找中文教程!一定给分!!!
- 救急,关于mysql不能正确启动的问题,请指教!
- mySQL 5.6 创建分区表错误
- 我是个新手,请教我如何安装mysql??怎样建立mysql的数据库?需要下载些甚么?98/NT 急急急!
- mysql 存储过程 返回值 ASP
- Hibernate+Oracle转Hibernate+MySql
你这个mysql的版本难道是4.x的?