Hi, Though MySQl initially provided support for Prepared statements in MySQL 5.0, they have removed that support in the later beta versions of MySQL 5.0. Right now MySQL does not recommend using prepared statements inside SP. So it would be better if you go for some work around's like using 'if else' loops.
sujay -----Original Message----- From: Shaghayegh Sahebie [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 19, 2005 1:55 PM To: mysql@lists.mysql.com Subject: Prepared statements in MySQL hi, i've got some questions: what happens when we deallocate a prepare statement? can we use same name for 2 prepared statements in a SP by deallocating first one before defining second one? can we use a prepare statement in a loop? can we use more than 1 prepared statement in a single SP? Thanks in advance Chagh --------------------------------- Start your day with Yahoo! - make it your home page -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]