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
mysql 动态 sql
最新推荐文章于 2022-06-05 16:03:31 发布