[Err] 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 'USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=gbk' at line 7出现这个错误原因好象是跟MYSQL数据库版本不对应有关,就是兼容性问题。本地的版本和服务器上的不一致的报错。
[Err] CREATE TABLE `dede_purview` (
`mid` mediumint(8) DEFAULT '0',
`typeid` smallint(5) DEFAULT '0',
`rank` smallint(6) DEFAULT NULL,
`pkey` varchar(30) CHARACTER SET latin1 NOT NULL,
`pvalue` text NOT NULL,
KEY `pkey` (`pkey`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
[Msg] Finished - Unsuccessfully
CREATE TABLE `dede_purview` ( o l e o u.com
`mid` mediumint(8) DEFAULT '0',
`typeid` smallint(5) DEFAULT '0',
`rank` smallint(6) DEFAULT NULL,
`pkey` varchar(30) CHARACTER SET latin1 NOT NULL,
`pvalue` text NOT NULL,
KEY `pkey` USING BTREE ( `pkey` )) ENGINE =MyISAM DEFAULT CHARSET=gbk;
友情赞助 | TAG标签 | baidumap | sitemap | RSS订阅 | 登陆邮箱 | 站内搜 |
Copyright ©copy; 2018 OLEOU 欢迎转载、评论。联系站长admin@oleou.com 港ICP备20120818号-1