mysql错误代码1054不知道是什么意思

Question

我在“字段列表”中收到错误代码 1054 未知列“interlake”

drop table if exists `Boats`;
create table `Boats` (
`bid` int(11) not null,
`bname` varchar(45) default null,
`color` varchar(15) default null,
 primary key (`bid`)
) engine=InnoDB default charset=latin1;

alter table `Boats` disable keys;
insert into `Boats` values
(101,`Interlake`,`blue`),(102,`Interlake`,`red`),(103,`Clipper`,`green`),(104,`Marine`,`red`);
alter table `Boats` enable keys;

Answer 1

使用引号代替反引号

INSERT INTO `Boats`
(`bid`, `bname`, `color`) 
VALUES  
(101,"Interlake","blue"),
(102,"Interlake","red"),
(103,"Clipper","green"),
(104,"Marine","red");