MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Classic SP problem
Posted by: Peter Brawley
Date: January 13, 2006 10:05AM

Christoph,

To get the result try SELECT ... INTO, ie

DECLARE pk INT DEFAULT NULL;
SELECT foodtype_pk INTO pk FROM foodtype WHERE foodtype_name = type;
IF pk IS NULL THEN ...

PB

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Classic SP problem
2151
Christoph Thompson
January 13, 2006 03:28AM
Re: Classic SP problem
1332
Peter Brawley
January 13, 2006 10:05AM
Re: Classic SP problem
1320
Roland Bouman
January 14, 2006 07:32AM
Re: Classic SP problem
1324
Christoph Thompson
January 16, 2006 02:22AM


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.