Re: Silent stored procedure

[Roland Bouman]

No, you can't supress it. I wouldn't know about the mem issue.
Are you aware of the SELECT INTO syntax? You see, this would solve it alltoghether.

create procedure myproc(
OUT p_maxLocalizationId int unsigned
)
begin

SELECT max(idLocalization)
INTO p_maxLocalizationId
FROM localization
;

end;

Now, you select the return value of max into a user variable (@maxId). It would be better to do this with a regular OUT parameter. That way, you can see immediately just by looking at the procedure's signature that it provides a value for maxid. I made that modification already in the snippet