Question

How do I pass a variable to a MySQL script?

Answer 1

CREATE PROCEDURE sp_test(var1 INT)

BEGIN

DECLARE start INT unsigned DEFAULT 1;

DECLARE finish INT unsigned DEFAULT 10;

SELECT var1, start, finish;

SELECT * FROM places WHERE place BETWEEN start AND finish;

END; //

DELIMITER ;