use mail;
delimiter $;
drop procedure if exists mlook;
create procedure mlook(in tbl varchar(10))
begin
SET @sqlcmd = concat('select * from ', tbl);
prepare stmt from @sqlcmd;
execute stmt;
deallocate prepare stmt;
end;
mysql存储过程使用表名做参数
最新推荐文章于 2024-07-22 03:15:38 发布