创建表时出现以下错误
create table check(
id int(9) auto_increment,
test_case varchar(20),
file_name varchar(200),
coverage int(5),
primary key(test_case,file_name));
当我收到以下错误时
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 'check( id int(9) auto_increment,test_case varchar(20),file_name
varchar(200),cov' at line 1
有 2 个(可能是 3 个)错误,1 检查是保留字,要么更改它或将其括在反引号中,2 id auto_increment并且必须定义为主键,3 定义的主键无效,因为 id 必须是主键。
create table `check`(
id int(9) auto_increment primary key,
test_case varchar(20),
file_name varchar(200),
coverage int(5),
key k1(test_case,file_name));