MySQL不支持动态表名

今天写一个数据迁移的存储过程，用到了动态表名，发现MYSQL不支持直接使用变量做表名。然后就用下面的方式来做了。

DROP PROCEDURE IF EXISTS p_transfer_data;
delimiter //  

CREATE PROCEDURE p_transfer_data()
begin 
  declare v_dbname varchar(100) default database();
  declare v_tabname varchar(100);
  declare flag int default 0;  /*是否达到记录的末尾控制变量*/
  
  DECLARE v_cur CURSOR FOR SELECT table_name FROM  information_schema.TABLES WHERE  TABLE_SCHEMA=v_dbname AND table_name like 't_2%' order by table_name desc;
  
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET flag = 1;
  open v_cur;
  FETCH v_cur INTO v_tabname;/*获取第一条记录*/
  
  while flag <> 1 do
    set @preparable_stmt1=CONCAT("insert into t_x(ID_,NAME)  select ID_,NAME ",v_tabname);
    set @preparable_stmt2=CONCAT("insert into t_y(ID_,AREA) select ID_,AREA from ",v_tabname);
	prepare preparable_stmt1 from @preparable_stmt1;
    prepare preparable_stmt2 from @preparable_stmt2;
    EXECUTE preparable_stmt1;
	EXECUTE preparable_stmt2;
	FETCH v_cur INTO v_tabname;/*取下一条记录*/
  end while;
  close v_cur;

end;
//

delimiter ;

-- call p_transfer_data();