Re: Variables in stored procedure

[Peter Brawley]

On 10/4/2011 4:20 PM, Adam Gerson wrote:

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?

See the manual page for PREPARE.

PB

-----

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

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