MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Using a variable with LIMIT in SELECT statement
Posted by: ddelanuez
Date: October 31, 2005 01:32PM

One more thing I noticed reading-up on prepared statements:

"SQL syntax for prepared statements cannot be used within stored routines (procedures or functions), or triggers. This restriction is lifted as of MySQL 5.0.13 for stored procedures, but not for stored functions or triggers."

So it won't work unless you're using a pretty recent version! (you should be using the production version anyway)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Using a variable with LIMIT in SELECT statement
CMS
October 10, 2005 03:35PM
Re: Using a variable with LIMIT in SELECT statement
ddelanuez
October 31, 2005 12:58PM
Re: Using a variable with LIMIT in SELECT statement
ddelanuez
October 31, 2005 01:22PM
Re: Using a variable with LIMIT in SELECT statement
ddelanuez
October 31, 2005 01:32PM
Re: Using a variable with LIMIT in SELECT statement
Felix Geerinckx
October 31, 2005 01:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.