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')     .

欢迎转载，但请保留出处，本文章转自[华软网] 原文链接：http://www.huarw.com/db/Mysql/200901/1660973.html