drop PROCEDURE if exists p_add;
create PROCEDURE p_add(out result int)
begin
declare a int;
declare b int;
declare c int;
select ContractAmount into a from A_CSLT_Contract limit 10;
select RealAmount into b from A_CSLT_Contract limit 10;
set c = a + b ;
select c into result;
end ;如何修改能够返回十条记录?
create PROCEDURE p_add(out result int)
begin
declare a int;
declare b int;
declare c int;
select ContractAmount into a from A_CSLT_Contract limit 10;
select RealAmount into b from A_CSLT_Contract limit 10;
set c = a + b ;
select c into result;
end ;如何修改能够返回十条记录?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货