创建存储过程错误（已解决）：Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ver

创建存储过程如下：

CREATE PROCEDURE showdb( v_offset int, v_pagesize int )
SELECT * FROM 'comment' ORDER BY id DESC LIMIT v_offset , v_pagesize;

但是提示：
Error Code : 1064
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＊＊＊＊＊＊

 

解决方法：

 

代码开头添加

DELIMITER 


||

末尾添加

DELIMITER ;


例如：


DELIMITER 


||




CREATE PROCEDURE showdb( v_offset int, v_pagesize int )  



SELECT * FROM 'comment' ORDER BY id DESC LIMIT v_offset , v_pagesize; 



DELIMITER ;

查询你当前数据库中的存储过程

select `name` from mysql.proc where db = 'your_db_name' and `type` = 'PROCEDURE'

user db;
show procedure status;