List:General Discussion« Previous MessageNext Message »
From:luiz rodrigo mottin Date:October 4 2011 9:29pm
Subject:Re: Variables in stored procedure
View as plain text  
you can use:
set @sql = concat( "INSERT INTO ", TABLENAME, "VALUES ('309', '0',
'statpress_mincap', 'edit_posts', 'yes')");
prepare stm from @sql;
execute @sql;

2011/10/4 Adam Gerson <agersonl@stripped>

> I am getting the error that "TABLENAME" does not exist. How do I get it to
> substitute the value stored in TABLENAME, and not the literal string?
>
> begin
>
> declare v_max int unsigned default 1;
> declare v_counter int unsigned default 21;
> declare TABLENAME text;
>
>  start transaction;
>  while v_counter <= v_max do
>        SET TABLENAME = CONCAT('wp_',v_counter, '_options');
>        INSERT INTO TABLENAME VALUES ('309', '0', 'statpress_mincap',
> 'edit_posts', 'yes');
>    set v_counter=v_counter+1;
>  end while;
>  commit;
> END
>
>
> Thanks,
> Adam
>
> --
> Adam Gerson
> Co-Director of Technology
> Columbia Grammar and Prep School
> phone. 212-749-6200 ex. 321
> fax.  212-428-6806
> agerson@stripped
> http://www.cgps.org
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?**
> unsub=luizrodrigomottin@gmail.**com<http://lists.mysql.com/mysql?unsub=1
>
>

Thread
Variables in stored procedureAdam Gerson4 Oct
  • Re: Variables in stored procedurePeter Brawley4 Oct
  • Re: Variables in stored procedureluiz rodrigo mottin4 Oct
    • Re: Variables in stored procedureAdam Gerson5 Oct
Re: Variables in stored procedureluiz rodrigo mottin5 Oct