browse: forums | FAQ

bytes

Hey there! Do you need MySQL Database help?

Get answers from our community of MySQL Database experts on BYTES! It's free.

Prepare statement allows only global variables?

getmeidea

Member

Join Date: Feb 2007

Posts: 36

#1: Oct 6 '08

Expand|Select|Wrap|Line Numbers

 SET @qry = 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';

PREPARE stmt2 FROM @s;

SET @first_param = 6;

SET @sec_param = 8;

EXECUTE stmt2 USING @first_param, @sec_param;

These are few lines in my stored procedure. Here if I change the identifiers @qry, @first_param, @sec_param to qry, first_param, sec_param respectively
mysql doesn't allow to compile the stored procedure.

Why only global variables are allowed here?

« previous question | next question »

Similar MySQL Database bytes

PDOStatement::prepare overhead (answers)
"with" statement, extending prototype (answers)
Packages, Bind, Prepare and Execute (answers)
The global statement (answers)

/bytes/development

/bytes/it

/bytes/other

misc

Forums
Visit our community forums for general discussions and latest on Bytes

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 231,098 network members.