mysql语法错误帮帮忙

chenjiaquan 2009-08-02 01:54:17

DROP TABLE IF EXISTS uchome_com_slave_luck;
CREATE TABLE uchome_com_slave_luck (
id mediumint(8) NOT NULL auto_increment,
`name` mediumtext NOT NULL,
amount varchar(8) NOT NULL default '',
range mediumint(8) NOT NULL default '0',
percent tinyint(3) NOT NULL default '0',
perday tinyint(2) NOT NULL default '0',
education char(3) NOT NULL default '',
experience char(3) NOT NULL default '',
health char(3) NOT NULL default '',
loyalty char(3) NOT NULL default '',
mood char(3) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=11;
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 'range mediumint(8) NOT NULL default '0', percent tinyint(8) NOT NULL default '0' at line 1

...全文

34 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

ACMAIN_CHM 2009-08-07

打赏
举报

range是关键字

mysql> CREATE TABLE uchome_com_slave_luck (

    ->   id mediumint(8) NOT NULL auto_increment,

    ->   `name` mediumtext NOT NULL,

    ->   amount varchar(8) NOT NULL default '',

    ->   `range` mediumint(8) NOT NULL default '0',

    ->   percent tinyint(3) NOT NULL default '0',

    ->   perday tinyint(2) NOT NULL default '0',

    ->   education char(3) NOT NULL default '',

    ->   experience char(3) NOT NULL default '',

    ->   health char(3) NOT NULL default '',

    ->   loyalty char(3) NOT NULL default '',

    ->   mood char(3) NOT NULL default '',

    ->   PRIMARY KEY  (id)

    -> ) ;

Query OK, 0 rows affected (0.11 sec)



mysql>