Question

You have an error in your SQL syntax; check the manual that corresponds to your MySQL......

php网站用帝国备份王在win2003系统下备份，现恢复liunx系统时数据库时出错，出现上述提示，我们是一个公益网站，请大虾们援助！
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, KEY `aid` (`aid`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=3 DE' at line 9
CREATE TABLE `cmseasy_a_attachment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `aid` int(11) DEFAULT NULL, `path` varchar(150) NOT NULL, `thumb` varchar(100) DEFAULT NULL, `intro` varchar(100) DEFAULT NULL, `adddate` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) USING BTREE, KEY `aid` (`aid`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8

Answer 1

试试如下代码：
CREATE TABLE `cmseasy_a_attachment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `aid` int(11) DEFAULT NULL, `path` varchar(150) NOT NULL, `thumb` varchar(100) DEFAULT NULL, `intro` varchar(100) DEFAULT NULL, `adddate` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` USING BTREE (`id`), KEY `aid` USING BTREE (`aid`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8