Question

我在导入数据的时候，出现以下错误，请各位大侠帮帮小弟，感激不尽！！

#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

AUTO_INCREMENT=1' at line 13

CREATE TABLE jdzcnnet_admin(
id MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
username VARCHAR( 30 ) NOT NULL DEFAULT '',
PASSWORD VARCHAR( 32 ) NOT NULL DEFAULT '',
adminlevel VARCHAR( 255 ) NOT NULL DEFAULT '1',
lastip VARCHAR( 50 ) NOT NULL DEFAULT '',
logintime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
lastime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
loginip VARCHAR( 30 ) NOT NULL DEFAULT '',
logins MEDIUMINT( 9 ) NOT NULL DEFAULT '0',
iswrite TINYINT( 4 ) NOT NULL DEFAULT '1',
PRIMARY KEY ( id )) TYPE = MYISAM AUTO_INCREMENT =1
是在phpmyadmin中导入

Answer 1

提示语法错误

追问

我知道是语法错误啊，问题是怎么改，谢谢！

追答

提示在此处
'TYPE=MyISAM

AUTO_INCREMENT=1' at line 13

有问题。