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
>
>
