Question

在mysql存储过程中使用limit 常量 没有问题.但是 limit 变量 编译不通过.如何解决?下面是我的代码！！很急

CREATE PROCEDURE pro_delAlbumById
(
IN id int
)
BEGIN
declare photoIds varchar(255);
declare photoCount int;
declare var int;

set var=0;
set photoCount = (select count(1) from tx_photo where a_id=id );
while var<photoCount do
if var=0 then
set photoIds = (select p_id from tx_photo where a_id=id limit var,1);
else
set photoIds = photoIds+','+(select p_id from tx_photo where a_id=id limit var,1);
end if;
set var=var+1;
end while;
select photoCount;
END;

Answer 1

LIMIT 接受一个或两个数字参数。参数必须是一个整数常量。