Store Procedure and Input Parameters

[Bing Li]

Hello all,

I am new to MYSQL and was creating a store proc with an update statement.

My update statement is as follows and works perfectly when i try to run it as shown below -

UPDATE test gu
SET gu.col1 = in_value
WHERE gu.col2 = in_value2
AND gu.col3 = in_value3 ;

Now i encapsulated this into a store procedure and it won't find the value and update at all. My store proc looks like this code below -


CREATE DEFINER=`glob`@`localhost` PROCEDURE `Update_TheID`(
IN `in_value` varchar(2000),
IN `in_value2` FLOAT,
IN `in_value3` FLOAT
)
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN

UPDATE test gu
SET gu.col1 = in_value
WHERE gu.col2 = in_value2
AND gu.col3 = in_value3 ;

END



Not sure what i am doing wrong, any help would be appreciated.

Thanks !