Re: Inserting errors into logs

[Peter Brawley]

See Get Diagnostics in the manual, it supports something like ...

drop table if exists t;
create table t(i int);
drop procedure if exists p;
delimiter go
create procedure p()
begin
  Declare Exit Handler for SqlException
    begin
      Get Diagnostics Condition 1 
        @sqlstate = Returned_SqlState,
        @errno = Mysql_Errno, 
        @text = Message_Text;
      Select @sqlstate, @errno, @text;
    end;
  insert into t set i="thisisastring";
end;
go
delimiter ;
call p();
drop table t;