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

#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;

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

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

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

Bookststus与bookState什么鬼

第一，把 create中的in去掉
第二，在create中的字段全为varchar，那在insert中的values中用引号；

建表那步把in去掉 类型给上长度
插入的时候字符串要加上单引号