Hi Friends,

I'm working on a migration project from Oracle to MySQL. We have lot of procedures in Oracle that needs to be converted to MySQL. I would like to know the equivalent of Oracle's "EXCEPTION when {exception} then ....." in MySQL.

For example, I would like to know whether the SQL Statement i'm firing within the procedure returns row or not - if no rows is returned then do logic a else do logic b

Thanks in advance

Hi,

Check SwisSQL.
http://www.swissql.com

Regards,

Thanks expert_db.

I used the HANDLERs for the above requirement. It works perfectly fine.

DECLARE EXIT HANDLER FOR NOT FOUND
begin
// Your logic for not found to be inserted here
end;