Take the 2-minute tour ×

I am stumped, and was hoping someone here would have a quick and easy answer. I did a fresh install of MySQL 5.5 and am trying to pass parameters into a stored procedure. The parameter values aren't being read by the stored procedure. MySQL doesn't throw an error and processes the code with null parameters. Here is the code:


CREATE DEFINER=`root`@`%` PROCEDURE `testing`(IN parameter INTEGER)
    UPDATE table_name SET valueToChange = 'Test' WHERE mainID = @parameter;

And here is the query I'm using to call it:

USE database_name; CALL testing(72);

Can anyone help?

share|improve this question
add comment

1 Answer

I knew it was something basic... I removed the "@" symbol from the variable and everything works perfectly :) Thanks to everyone that looked into this for me!

share|improve this answer
add comment

Your Answer


