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

Question

SQL 错误: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 'TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci' at line 9查询:CREATE TABLE mybb_adminlog ( uid int unsigned NOT NULL default '0', ipaddress varchar(50) NOT NULL default '', dateline bigint(30) NOT NULL default '0', module varchar(50) NOT NULL default '', action varchar(50) NOT NULL default '', data text NOT NULL, KEY module (module, action) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

Answer 1

你这个建表语句应该是mysql比较老的版本，指定引擎还是用type的，吧type改成engine吧
是engine=myisam，其实把type=myisam去掉也可以，因为默认就是myisam引擎

Answer 2

我使用navicat执行你报错的语句成功。看起来跟mysql版本的有关，我的mysql版本是
mysql Ver 14.14 Distrib 5.1.57, for Win32 (ia32)

把建表语句改成以下再试试：
CREATE TABLE `mybb_adminlog` (
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`ipaddress` varchar(50) NOT NULL DEFAULT '',
`dateline` bigint(30) NOT NULL DEFAULT '0',
`module` varchar(50) NOT NULL DEFAULT '',
`action` varchar(50) NOT NULL DEFAULT '',
`data` text NOT NULL,
KEY `module` (`module`,`action`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;本回答被提问者和网友采纳

Answer 3

把TYPE改成engine就可以了