CREATE PROCEDURE proc_getBBSParentLst(IN rootId INT,IN m INT,IN n INT)
BEGIN
select * from CXTABLE_BBS
where FIND_IN_SET(id, getBBSParentLst(rootId))
order by dateline desc limit m,n;
END
//
在 windows下,可以正常运行,但是在linux下一直提示:
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 'm,n;
END' at line 5
如果m,n都改成10这样的数字,就可以执行通过,请问是怎么回事? 谢谢。
...全文
1163打赏收藏
请教linux下mysql 存储过程的报错问题
CREATE PROCEDURE proc_getBBSParentLst(IN rootId INT,IN m INT,IN n INT) BEGIN select * from CXTABLE_BBS where FIND_IN_SET(id, getBBSParentLst(rootId)) order by dateline desc limit m,n; END // 在 windows下,可以正常运行,但是在linux下一直提示: ERROR 1064 (42000): You ha