Integer in MySQL procedure, syntax error
- by confiq
I made simple procedure just to demonstrate
CREATE PROCEDURE `demo`(demo_int int)
BEGIN
DECLARE minid INT;
SELECT min(id) FROM (SELECT id FROM events LIMIT demo_int,9999999999999999) as hoo INTO minid;
END$$
The problem is with demo_int, if i change it to
LIMIT 1,9999999999999999
it works but
LIMIT demo_int,9999999999999999
Does…
