mysql 动态 sql

BEGIN/****declare cnt int ;set @stmt = concat('select count(1) from player_item_00  into @v_cnt;');PREPARE stmt1 FROM @stmt;EXECUTE stmt1;deallocate prepare stmt1;set cnt = @v_cnt  ;select cnt;**/declare str varchar(200) ;declare i int default 0;set @v_table_name = concat(' player_item_0',i);set @v_condition  = concat(' where id = 1');set @v_player_id = concat(' where player_id=' ,player_id);set @stmt = concat('select  * from ',@v_table_name,@v_player_id);PREPARE stmt1 FROM @stmt;EXECUTE stmt1;END