BEGIN
set @amd=albumid;
set @bpe=beginPage;
set @epe=endPage; select u_photo_name,u_photo_url from user_photo_info where u_document_id=@amd LIMIT @bpe,@epe; END 为什么报错,是不是我的limit写错了
谢谢
set @amd=albumid;
set @bpe=beginPage;
set @epe=endPage; select u_photo_name,u_photo_url from user_photo_info where u_document_id=@amd LIMIT @bpe,@epe; END 为什么报错,是不是我的limit写错了
谢谢
mysql> SET @s = 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';
mysql> PREPARE stmt2 FROM @s;
mysql> SET @a = 6;
mysql> SET @b = 8;
mysql> EXECUTE stmt2 USING @a, @b;