create procedure usp_SendSms
(
in p_mobilephone varchar(15),
in p_content varchar(400),
out p_id int(10)
)
begin
start transaction;
set p_id:=(select max(id) from guangbo for update);
set p_id:=p_id+1;
insert into guangbo(id,mobilephone,content) values(p_id,p_mobilephone,p_content);
commit;
end;
