使用mysql的存储过程执行动态sql语句
delimiter //
create procedure proce2(in old varchar(100), in newT varchar(100))
begin
declare my_sql varchar(500);
set my_sql = concat('create table ',newT,' like ',old);
set @ms = my_sql;
prepare s1 from @ms;
execute s1;
deallocate prepare s1;
end//