编程论坛 » MySQL » [求助]这段SQL代码到底错在哪

lxclinton 发表于 2007-7-22 21:44

[求助]这段SQL代码到底错在哪

DROP TABLE IF EXISTS users;<BR>CREATE TABLE users(<BR>  'USER_ID' VARCHAR(50) NOT NULL DEFAULT'',<BR>  'PASSWORD' VARCHAR(20) NOT NULL DEFAULT'',<BR>  'NAME' VARCHAR(8) NOT NULL DEFAULT'',<BR>  'SEX' CHAR(6) NOT NULL DEFAULT'male',<BR>  'BIRTH' bigint NOT NULL,<BR>  'DESCRITION' VARCHAR(256) NOT NULL DEFAULT'',<BR>  PRIMARY KEY ('USER_ID')<BR>) ENGINE=InnoDB DEFAULT CHARSET=utf8;<BR><BR><BR><BR><BR>系统显示如下错误信息：<BR>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 ''USER_ID' VARCHAR(50) NOT NULL DEFAULT'',<BR>  'PASSWORD' VARCHAR(20) NOT NULL DEF' at line 2<BR>

lmhllr 发表于 2007-7-24 00:42

不用加逗号<BR>[code]<BR>DROP TABLE IF EXISTS users;<BR>CREATE TABLE users(<BR>  USER_ID VARCHAR(50) NOT NULL DEFAULT '',<BR>  PASSWORD VARCHAR(20) NOT NULL DEFAULT '',<BR>  NAME VARCHAR(8) NOT NULL DEFAULT '',<BR>  SEX CHAR(6) NOT NULL DEFAULT 'male',<BR>  BIRTH bigint NOT NULL,<BR>  DESCRITION VARCHAR(256) NOT NULL DEFAULT '',<BR>  PRIMARY KEY (USER_ID)<BR>) ENGINE=InnoDB DEFAULT CHARSET=utf8;<BR>[/code]

myfor 发表于 2007-7-25 20:43

要加就加````````````````````````````````````````这种符号

fengxfu 发表于 2007-7-28 22:11

[em10]

查看完整版本: [求助]这段SQL代码到底错在哪