Try catch in MYSQL Stored procedures

[PeriyasamyRamachandran]

Hi All, I am new in MYSQL Database. I am using the interface SQLYog tool. I just want simple stored procedure with INSERT query and it should be handled exception handling(Try-catch). If the records are inserted in a table then the procedure should return 1. If the records are not inserted(because Exception may occured) then the procedure should return 0. Cau anybody help me? Please.. Thanks, Periyasamy Ramachandiran.

[N a v a n e e t h]

See this[^] setting handlers. To see the insertion/updation/deletion failure/success status, check row_count(). Something like,

--your insert query
IF (row_count()[^]> 0) THEN
--insertion success
ELSE
..failure

Navaneeth How to use google | Ask smart questions

[PeriyasamyRamachandran]

Navaneeth, Thanks for your reply. Let me try this. -Periyasamy Ramachandiran.