SinggahDapur
20th November 2011, 01:16 AM
para webmaster ane mo nanya nih. klo clausa limit di mysql kan pake limit {start}, {count}. tapi klo {start} dan {count} dijadiin parameter dalam stored procedure kok jadi error ya:
CREATE PROCEDURE show_user (IN start INT, IN count INT)
BEGIN
SELECT * FROM users LIMIT start, count;
END
error gan, tp klo {start} dan {count} nya d ganti angka engga error ???
</div>
CREATE PROCEDURE show_user (IN start INT, IN count INT)
BEGIN
SELECT * FROM users LIMIT start, count;
END
error gan, tp klo {start} dan {count} nya d ganti angka engga error ???
</div>