Mysql:ERROR 1064(42000):你的SQL语法有一个错误

Question

我想创建一个过程，但是MySQL命令行给了我这个错误:

mysql> delimiter $$
mysql> use publisher$$
Database changed
mysql> create definer='ashix'@'localhost' procedure 'GroupBookProc' (IN groupIdBook varchar(6))
-> BEGIN
-> select * from GroupBook where groupID = groupIdBook;
-> END $$
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 ''GroupBookProc' (IN groupIdBook varchar(6))
BEGIN
select * from GroupBook where ' at line 1

我该怎么办?

Answer 1

谢谢@ErgestBasha我从'GroupBookProc'中删除引号，它工作