1

In my mysql stored procedure I want try catch block but it gives error in my mysql stored procedure .

I want my select query to be in try block and if it executes correctly I want other query to execute.

code statement for mysql 

BEGIN
 begin try 
     select userId into user from users ;
 end try
 begin catch 
    select 1;
 end catch 
 begin finally
   select postId from photo where userId=user;
 end finally 
END

but it gives error is there any try catch block for mysql.

Ankita.P
  • 155
  • 1
  • 1
  • 6

1 Answers1

0

I think you're mixing up Java (other language?) with MySQL's stored procedure language. Look here and here. Check out this by Guy Harrison, the guy who wrote this book.

Community
  • 1
Vérace
  • 29,825
  • 9
  • 70
  • 84