In the code below,
CREATE PROCEDURE UserCheck (
IN param1 VARCHAR(32)
)
BEGIN
DECLARE var1 INT(10);
what is the difference between param1 and var1?
Asked
Active
Viewed 33 times
0
-
A lot. One is a passed in parameter, one is a local variable declared within the stored procedure. One is a `varchar` and one is an `int`. What are you unclear about? – sgeddes Dec 10 '15 at 22:14
-
This sounds like a homework question. – Uueerdo Dec 10 '15 at 22:15
-
@WesPalmer, so rude of you to say that. i am coming from a DB with no stored procedures. Currently I am starting to learn MySQL. Stored procedures are pretty new to me. – Dave Dec 11 '15 at 21:12