/>I'm trying to make stored procedures use parameters for limit and
>guess this is either me using the wrong datatype or it's not
>having the same issue with seting the table for the query:
SET @sql = CONCAT( 'select * from some_table limit ', some_limit );
PREPARE stmt FROM @sql
> Jon wrote:
>> Hi list
>> I'm trying to make stored procedures use parameters for limit and
>> tables, I
>> guess this is either me using the wrong datatype or it's not
>> possible. I'm
>> having the same issue with seting the table for the query:
>> CREATE PROCEDURE sp_test1 (IN some_limit int)
>> select * from some_table limit some_limit;
>> CREATE PROCEDURE sp_test2 (IN some_table table)
>> select * from some_table;
>> Both fail with "ERROR 1064 (42000)".
>> Can someone please shed some light on this for me? Is this a problem
>> procedures not being able to do this or is it wrong datatypes or
>> completely different?
>> Thanks in advance
> It sounds like what you need is dynamic SQL in your stored procedures.
> Check out http://forge.mysql.com/snippets/view.php?id=13 for some good
> examples, more complex than what you're asking about, but they should
> shed light on what you need to do.
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/403 - Release Date: 7/28/2006