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') .
欢迎转载,但请保留出处,本文章转自[华软网] 原文链接:http://www.huarw.com/db/Mysql/200901/1660973.html