winds512tom
(winds512tom)
新手上路
初级会员
UID 62549
精华
0
积分 7
帖子 5
金钱 7 喜悦币
威望 0
人脉 0
阅读权限 10
注册 2004-12-17
状态 离线
|
mysql的存储过程问题
mysql版本5.0.37：
create procedure p1 (pi int,ps int)
begin error,提示不支持
SET @a=CONCAT("SELECT * FROM t LIMIT ",(pi-1)*ps,",",ps)
PREPARE sql FROM @a 报错
EXECUTE sql 报错
end error,提示不支持
错误如下：
#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 'PREPARE sql FROM "SELECT * FROM t"
EXECUTE sql
end p1' at line 4
|
|
