参考:create procedure countNum ( in tbName varchar(100), out allPages int ) begin set @sqlStr = CONCAT('select count(*) into @allPages from ',tbName); prepare sqlstmt from @sqlStr; execute sqlstmt;set allPages = @allPages;deallocate prepare sqlstmt; end;
(
in tbName varchar(100),
out allPages int
)
begin
set @sqlStr = CONCAT('select count(*) into @allPages from ',tbName);
prepare sqlstmt from @sqlStr;
execute sqlstmt;set allPages = @allPages;deallocate prepare sqlstmt;
end;