create table customer
(userid varchar(20)primary key,
username varchar(20) not null,
'password' varchar(30) not null,
age int(3) not null ,
gender varchar(4) check(gender in('男','女'))not null,
address varchar(30) not null,
tel varchar(20) not null
)
mysql语句添加表包错了 求大虾指正
(userid varchar(20)primary key,
username varchar(20) not null,
'password' varchar(30) not null,
age int(3) not null ,
gender varchar(4) check(gender in('男','女'))not null,
address varchar(30) not null,
tel varchar(20) not null
)
mysql语句添加表包错了 求大虾指正
(userid varchar(20)primary key,
username varchar(20) not null,
`password` varchar(30) not null,
age int(3) not null ,
gender varchar(4) check(gender in('男','女'))not null,
address varchar(30) not null,
tel varchar(20) not null
)
另外建议把错误信息一共贴出以供别人分析。
[MySql] ERROR 1064: 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 'null,
address varchar(30) not null,
tel varchar(20) not null' at line 6
(userid VARCHAR(20)PRIMARY KEY,
username VARCHAR(20) NOT NULL,
`password` VARCHAR(30) NOT NULL,
age INT(3) NOT NULL ,
gender ENUM('男','女'),
address VARCHAR(30) NOT NULL,
tel VARCHAR(20) NOT NULL
)
(userid INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(20) NOT NULL,
`password` VARCHAR(30) NOT NULL,
age INT(3) NOT NULL ,
gender ENUM('男','女'),
address VARCHAR(30) NOT NULL,
tel VARCHAR(20) NOT NULL
)
(userid VARCHAR(20)PRIMARY KEY,
username VARCHAR(20) NOT NULL,
`password` VARCHAR(30) NOT NULL,
age INT(3) NOT NULL ,
gender ENUM('男','女'),
address VARCHAR(30) NOT NULL,
tel VARCHAR(20) NOT NULL
)