MySQL Forums
Forum List  »  Stored Procedures

Re: Silent stored procedure
Posted by: Roland Bouman
Date: December 16, 2005 04:24AM

Ok. then, definitely, do away with the user variable, and just declare a local variable:

create procedure myproc(
)
begin
declare v_maxLocalizationId int unsigned;

SELECT max(idLocalization)
INTO v_maxLocalizationId
FROM localization
;

end;

Options: ReplyQuote


Subject
Views
Written By
Posted
3052
December 16, 2005 03:43AM
2603
December 16, 2005 03:56AM
1539
December 16, 2005 04:14AM
Re: Silent stored procedure
1651
December 16, 2005 04:24AM
1493
December 16, 2005 04:14AM
1914
December 16, 2005 04:19AM
1540
December 16, 2005 06:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.