Cleanshot Cleanshot - 1 year ago 52
SQL Question

mysql error code 1054 not sure what it means

I am getting the error code 1054 Unknown column 'interlake' in 'field list'

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
alter table `Boats` enable keys;

Answer Source

Use quotes instead of back ticks

(`bid`, `bname`, `color`)