Variables in stored procedure

[Adam Gerson]

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
ager...@cgps.org
http://www.cgps.org


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org