mysql 动态传入表名 存储过程_mysql表名作为参数传入存储过程

有以下存储过程：

create definer=`root`@`localhost` procedure `p_hovertreepages`(

in `tablename` varchar(200),

in `fieldlist` varchar(2000)

,

in `primarykey` varchar(100),

in `where` varchar(2000),

in `order` varchar(1000),

in `sorttype` int,

in `recordercount` int,

in `pagesize` int,

in `pageindex` int,

out `totalcount` int,

out `totalpagecount` int

)

language sql

not deterministic

contains sql

sql security definer

comment 'fenye'

begin

set @sqlstr = concat('select * from ',tablename);

prepare sqlstr from @sqlstr;

execute sqlstr;

end

有这个表：

调用存储过程：

call `p_hovertreepages`('t_hovertreenote', 'h', 'h', 'h', 'h', '1', '1', '2', '1', @hh, @yy)

结果：

如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！