GET DIAGNOSTICS equivalent for mysql version older than 5.6 -


is there equivalent diagnostics of mysql 5.6 version lower versions of mysql?

i using mysql 5.5 , want this

declare exit handler sqlexception  begin     rollback;     diagnostics condition 1      @p1 = mysql_errno, @p2 = returned_sqlstate, @p3=message_text,@p4=table_name;     select concat('failed - ',@p1,@p2,@p3,@p4); end; 

but 5.5 doesn't support this, there work around this?


Comments

Popular posts from this blog

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

html - How to style widget with post count different than without post count -

url rewriting - How to redirect a http POST with urlrewritefilter -