求助：MySQL语句错误，我找不出错误地方

Question

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'in author varchar,in ISBN varchar,in bookID varchar,in publisher varchar,in book' at line 1

 CREATE PROCEDURE bookinfoinput_pro(in bookName varchar,in author varchar,in ISBN varchar,in bookID varchar,in publisher varchar,in bookType varchar,in booktime date,in price decimal,in bookState varchar)
BEGIN
insert into bookinfo (Bookname, Author, ISBN, BookID, Publisher, Booktype, bookdate, Price,  Bookststus )
values ( bookName, author, ISBN, bookID, publisher, bookType, booktime, price, bookState);
END;

求各位大神搭救，实在找不出错误地方，谢谢

Answer 1

报错的地方说的很清楚，是你的语法有问题，把字段类型varchar给长度，例如varchar(10)。

参考自：
MySQL存储过程详解 http://www.data.5helpyou.com/article314.html