Mysql创建数据表报错，望指点迷津

Question

mysql> create table caseinfo(
    -> caseid char(20) primary key,
    -> name char(20) not null,
    -> sex char(2) not null,
    -> age int not null,
    -> abte char(10),
    -> userid char(10),
    -> condition nvarchar(500),
    -> physics nvarchar(200),
    -> recipe nvarchar(500),
    -> cnum int not null,
    -> items nvarchar(200)
    -> )
    -> ;

ERROR 1064 (42000): 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 'condition nvarchar(500),
physics nvarchar(200),
recipe nvarchar(500),
cnum int n' at line 8

Answer 1

create table caseinfo(
caseid char(20) primary key,
name char(20) not null,
sex char(2) not null,
age int not null,
abte char(10),
userid char(10),
`condition` nvarchar(500),
physics nvarchar(200),
recipe nvarchar(500),
cnum int not null,
items nvarchar(200)
)
;

注意保留字