日期:2014-05-16  浏览次数:20709 次

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吧