开发者社区> 问答> 正文

mysql "the right syntax to use near 'not null comment '身份'"

代码如下:

create table admin(

id int(4) not null primary key auto_increment comment '用户id',

uname varchar(50) not null unique comment '用户名',

passwd varchar(50) not null comment '密码',

degree varchar(200) check (degree = '管理员' or degree = '普通用户') not null comment '身份',

popedom int(4) check (popedom = 0 or degree = 1) not null comment '权限',

truename varchar(50)  comment '真实姓名',

sex varchar(20) check (sex = '男' or sex = '女') comment '性别', 

age int(4) check (age >=0 and age <=100) comment '年龄',

phone varchar(50) comment unique '手机号码',

address varchar(200) comment '家庭地址',
)

报错信息:
[Err] 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 'not null comment '身份',
popedom int(4) check (popedom = 0 or degree = 1) n' at line 9

展开
收起
蛮大人123 2016-02-08 18:02:34 5199 0
1 条回答
写回答
取消 提交回答
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像