怎样得到mysql存储过程多条语句的结果集

create procedure getResult(
in name varchar(30),
in classNames varchar(30)
)
begin
select userName from lxlog where userName=name;
select className from lxuser where className=classNames;
select sum(validTime) as onePersonValidTime from lxlog where userName=name;
select sum(validTime) as classValidTime from lxlog where userName in (select userName from lxuser where className =classNames);
end

call getResult('person','3class')
怎样得到这四条语句的每一条语句的结果集?
展开阅读全文

没有更多推荐了,返回首页