mysql存储过程使用表名做参数

use mail;delimiter $;drop procedure if exists mlook;create procedure mlook(in tbl varchar(10))beginSET @sqlcmd = concat('select * from ', tbl);prepare stmt from @sqlcmd;execute stmt;deallocate prepare stmt;end;