MySQL Forums
Forum List  »  Oracle

SELECT..INTO...NO_DATA_FOUND and TOO_MANY_ROWS
Posted by: Paul van Keulen
Date: September 24, 2008 12:50AM

Hi,
I've worked several years with Oracle, now I'm into mysql.
In Oracle I've got the situation:

Begin
SELECT author_last_name
INTO v_authName
FROM authors
WHERE author_state = v_auth_state;

// work with v_authname
When NO_DATA_FOUND
// do something
When TOO_MANY_ROWS then
// do something
END;

How can I translate (SELECT..INTO...NO_DATA_FOUND and TOO_MANY_ROWS) above situation to MySql?

Regards,
Paul

Options: ReplyQuote


Subject
Views
Written By
Posted
SELECT..INTO...NO_DATA_FOUND and TOO_MANY_ROWS
13213
September 24, 2008 12:50AM


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.