MySQL Forums
Forum List  »  General

Re: PREPARED Statement use in Query Browser (BUG?)
Posted by: Donald West
Date: February 26, 2007 02:28PM

Hi Willian

The problem is not with user defined variables in the Query Browser. You can get around that by using Transactions as I did in my example code ie, START TRANSACTION; and COMMIT; or you can use the buttons on the toolbar on top of the screen.

The problem is in using variables in the LIMIT with the use of PREPARE. If this also does not work in the Query Browser, perhaps there is a workaround as there is with user defined variable usage. Or if not, do you have any suggestions as to how to accomplish the equivalent of using a LIMIT with a variable number of rows?


Options: ReplyQuote

Written By
Re: PREPARED Statement use in Query Browser (BUG?)
February 26, 2007 02:28PM

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.