注册 登录
编程论坛 MySQL论坛

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

lxclinton 发布于 2007-07-22 21:44, 1497 次点击
DROP TABLE IF EXISTS users;
CREATE TABLE users(
'USER_ID' VARCHAR(50) NOT NULL DEFAULT'',
'PASSWORD' VARCHAR(20) NOT NULL DEFAULT'',
'NAME' VARCHAR(8) NOT NULL DEFAULT'',
'SEX' CHAR(6) NOT NULL DEFAULT'male',
'BIRTH' bigint NOT NULL,
'DESCRITION' VARCHAR(256) NOT NULL DEFAULT'',
PRIMARY KEY ('USER_ID')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




系统显示如下错误信息:
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'',
'PASSWORD' VARCHAR(20) NOT NULL DEF' at line 2
3 回复
#2
lmhllr2007-07-24 00:42
不用加逗号

DROP TABLE IF EXISTS users;
CREATE TABLE users(
  USER_ID VARCHAR(50) NOT NULL DEFAULT '',
  PASSWORD VARCHAR(20) NOT NULL DEFAULT '',
  NAME VARCHAR(8) NOT NULL DEFAULT '',
  SEX CHAR(6) NOT NULL DEFAULT 'male',
  BIRTH bigint NOT NULL,
  DESCRITION VARCHAR(256) NOT NULL DEFAULT '',
  PRIMARY KEY (USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#3
myfor2007-07-25 20:43
要加就加````````````````````````````````````````这种符号
#4
fengxfu2007-07-28 22:11
1