Error: You have an error in your SQL syntax. Check the manual that correspon

来源：百度知道编辑：UC知道时间：2024/06/20 14:14:33

Apache v1.3.29 (Win32)
PHP v4.3.4 (Win32)
Zend Optimizer v2.1.0 (Win32)
MySQL v4.0.17(Win32)
ActivePerl v5.8.0.806(Win32)
在安装时出现了以下问题，怎么解决啊
User: admin
Time: 2009-5-29 10:57pm
Script: /install_lottery.php

SQL: CREATE TABLE `[Table]plugin_lottery_term` (
`termid` mediumint(8) unsigned NOT NULL default 1,
`num1` int(2) unsigned default NULL,
`num2` int(2) unsigned default NULL,
`num3` int(2) unsigned default NULL,
`num4` int(2) unsigned default NULL,
`num5` int(2) unsigned default NULL,
`num6` int(2) unsigned default NULL,
`seldout` mediumint(8) unsigned NOT NULL,
`run` tinyint(1) unsigned NOT NULL default 0,
`num7` int(2) unsigned default NULL,
`opendate` date NOT NULL default '0000-00-00',
`realopen` varchar(20) NOT NULL default ' ',
`forceflg` tinyint(1) default 0
PRIMARY KEY (`termid`)
);
Error: You have an error in your SQL syntax. Check

建主键那里少个逗号','
CREATE TABLE `[Table]plugin_lottery_term` (
`termid` mediumint(8) unsigned NOT NULL default 1,
`num1` int(2) unsigned default NULL,
`num2` int(2) unsigned default NULL,
`num3` int(2) unsigned default NULL,
`num4` int(2) unsigned default NULL,
`num5` int(2) unsigned default NULL,
`num6` int(2) unsigned default NULL,
`seldout` mediumint(8) unsigned NOT NULL,
`run` tinyint(1) unsigned NOT NULL default 0,
`num7` int(2) unsigned default NULL,
`opendate` date NOT NULL default '0000-00-00',
`realopen` varchar(20) NOT NULL default ' ',
`forceflg` tinyint(1) default 0,
PRIMARY KEY (`termid`)
);

You have an error in your SQL syntax Have you got ,Have you gotten 区别 have you 和 do you have ~~~ 请问这段代码为什么总是显示You have an error in your SQL syntax....at line 1 You never have noddles , ( ) you? gDo you have??? Have you ever noticed you have my word you should have studied Where have you been?