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

Answer 1

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)  not null comment '身份' check (degree = '管理员' or degree = '普通用户'),

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

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

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

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

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

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

Like above, change the position of the check clause and the position of the penultimate field unique in all statements, and the table can be successfully created.

However, please note: MySQL does not support check. Although the table can be created, all the check clauses in it are ignored (adding it has no effect) , please refer to the official documentation for details:

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

"All storage engines parse the CHECK clause, but ignore the CHECK clause."
The CHECK clause is parsed but ignored by all storage engines.