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吧