win7往mysql导入sql文件报错

[feichanghunger]

错误是
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to
sql文件是

create table customers
( customerid int unsigned not null auto_increment primary key,
  name char(50) not null,
  address char(100) not null,
  city char(30) not null
);

create table orders
( orderid int unsigned not null auto_increment primary key,
  customerid int unsigned not null,
  amount float(6,2),
  date date not null
);

create table books
(  isbn char(13) not null primary key,
   author char(50),
   title char(100),
   price float(4,2)
);

create table order_items
( orderid int unsigned not null,
  isbn char(13) not null,
  quantity tinyint unsigned,

  primary key (orderid, isbn)

);
create table book_reviews
(
  isbn char(13) not null primary key,
  review text
);

求大神解答，感谢

[xuzuning]

测试了一次，并未发现有错误

[深圳phper]

你MYSQL是什么版本的，我执行了下也没问题呀

[feichanghunger]

可能是导入重复或者是用户没有权限，用root删除导入的，用root重新导入就好了，谢谢大家的帮助