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 <agers...@cgps.org> > 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=luizrodrigomottin@gmail.**com<http://lists.mysql.com/mysql?unsub=luizrodrigomot...@gmail.com> > >