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=utf8;
错误在第七行 ,把 USING BTREE 放到 (`pkey`)的前面,就可以了
KEY `pkey` (`pkey`) USING BTREE 修改为
KEY `pkey` USING BTREE (`pkey`)