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();