#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL serve---- Table structure for table `level`--CREATE TABLE level ( idx int(11) NOT NULL auto_increment, name varchar(30) default NULL, condition int(11) d

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/04 11:32:58
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL serve---- Table structure for table `level`--CREATE TABLE level (  idx int(11) NOT NULL auto_increment,  name varchar(30) default NULL,  condition int(11) d

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL serve---- Table structure for table `level`--CREATE TABLE level ( idx int(11) NOT NULL auto_increment, name varchar(30) default NULL, condition int(11) d
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL serve
--
-- Table structure for table `level`
--
CREATE TABLE level (
idx int(11) NOT NULL auto_increment,
name varchar(30) default NULL,
condition int(11) default NULL,
bCondition enum('y','n') NOT NULL default 'y',
price_cut float default '0',
point_cut float default '0',
trans_cut enum('y','n') NOT NULL default 'n',
bUse enum('y','n') NOT NULL default 'y',
part enum('M','D','B','E') NOT NULL default 'M',
level tinyint(4) NOT NULL default '0',
writeday datetime NOT NULL default '0000-00-00 00:00:00',
margin_cut tinyint(4) default NULL,
login_msg varchar(255) default NULL,
PRIMARY KEY (idx),
KEY bUse (bUse)
) TYPE=MyISAM COMMENT='�����';

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL serve---- Table structure for table `level`--CREATE TABLE level ( idx int(11) NOT NULL auto_increment, name varchar(30) default NULL, condition int(11) d
在您的SQL中第四行 :condition int(11) default NULL,
这个里的列明为系统关键字,不能使用.换个别的就可以了,
比如:conditiona int(11) default NULL,
希望能给您提供点信息.