转换出错 泪奔在线等QAQ

提示这个 该怎么办QAQ


>> PHPWind 8.5 => Discuz! X2 转换程序
欢 迎 使 用 本 程 序

XConvert info: MySQL Query Error

Time: 2012-3-17 9:38am
SQL: CREATE TABLE sq_xgtx.pre_xreports (
rid int(10) unsigned NOT NULL AUTO_INCREMENT,
step tinyint(2) unsigned NOT NULL DEFAULT '0',
errnum mediumint(8) unsigned NOT NULL DEFAULT '0',
message mediumtext NOT NULL DEFAULT '',
PRIMARY KEY (rid),
KEY step (step)
) TYPE=MyISAM AUTO_INCREMENT=100;
Error: 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=100' at line 8
Errormsg.: 可能原因：1.数据超长或类型不匹配；2.数据库记录重复
Errno.: 1064

用PHPMYADMIN建下表

1. CREATE TABLE sq_xgtx.pre_xreports (
   
2. rid int(10) unsigned NOT NULL AUTO_INCREMENT,
   
3. step tinyint(2) unsigned NOT NULL DEFAULT '0',
   
4. errnum mediumint(8) unsigned NOT NULL DEFAULT '0',
   
5. message mediumtext NOT NULL DEFAULT '',
   
6. PRIMARY KEY (rid),
   
7. KEY step (step)
   
8. ) TYPE=MyISAM AUTO_INCREMENT=100;
   

复制代码

baxter 发表于 2012-3-17 17:59
用PHPMYADMIN建下表

那个..QAQ请问怎么建...

进入phpmyadmin，打开你的数据库，有个sql选项，把代码复制进去执行即可