下面这个问题一直困扰着我,到底怎么解决呢?求高手指点
mysql> create database b;
Query OK, 1 row affected (0.00 sec)
mysql> use b;
Database changed
mysql> create table bi(
-> id int(10) not null auto_increment,
-> bookname varchar(45) not null default",
"> author varchar(45) not null default",
-> price float not null default 0,
-> primary key(id)
-> )engine InnoDB default charset=gb2312;
Query OK, 0 rows affected (0.03 sec)
mysql> insert into bi(id,bookname,author,price)values
-> (1,'web开发教程','张文',35),
-> <2,'汇编语言程序','王叶昂',28),
-> <3,'爱情级别','王亚明',27);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '<2,'
汇编语言程序','王叶昂',28),
<3,'爱情级别','王亚明',27)' at line 3
mysql>
[解决办法]
<2,'汇编语言程序','王叶昂',28),
(2,'汇编语言程序','王叶昂',28),
无语阿
[解决办法]