Getting SQLEXCEPTION message in MySQL procedures

Question

How can I get error text in MySQL stored procedure when SQLEXCEPTION occurs?

I need something like this:

DECLARE EXIT HANDLER FOR SQLEXCEPTION    
BEGIN
    INSERT INTO my_log (error_message) 
    VALUES (SQLEXCEPTION.message);
END;

Answer 1

DECLARE EXIT HANDLER FOR SQLEXCEPTION    
BEGIN

 GET DIAGNOSTICS CONDITION 1
    @p2 = MESSAGE_TEXT;

    INSERT INTO my_log (error_message) 
    SELECT @p2;
END;