1054错误
查询语句是这样的：
insert into book values (“study asp.net”,”zhejiang print”,”jackson”,”2009/07″,”2010/4/13″,30);
表的结构是这样的：
book(book_name varchar(45) primary,
print_name varchar(45),
author varchar(45),
print_time char(7),
in_time char(10) not null,
price decimal(4,0)
);
报错：Unknown column ‘count’ in ‘field list’ 为嘛呢？
-
SQL code
create table book ( book_name varchar(45) primary key, print_name varchar(45), author varchar(45), print_time char(7), in_time char(10) not null, price decimal(4,0) );
Unknown column 'count' in 'field list' 为嘛呢？
确定是否有列名count吧
