查询语句是这样的:
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' 为嘛呢?
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' 为嘛呢?
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)
);mysql> 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)
-> );
Query OK, 0 rows affected (0.00 sec)mysql>
mysql> insert into book values ("study asp.net","zhejiang print","jackson","2009/07","2010/4/13",30);
Query OK, 1 row affected (0.00 sec)mysql> select * from book;
+---------------+----------------+---------+------------+-----------+-------+
| book_name | print_name | author | print_time | in_time | price |
+---------------+----------------+---------+------------+-----------+-------+
| study asp.net | zhejiang print | jackson | 2009/07 | 2010/4/13 | 30 |
+---------------+----------------+---------+------------+-----------+-------+
1 row in set (0.00 sec)
我这执行成功,你再试试。
+-----------+
| version() |
+-----------+
| 5.1.35 |
+-----------+
1 row in set (0.00 sec)