create or replace table t1 (pk int primary key, a char(3));

insert ignore into t1 values (1,'foo'),(1,'bar'),(2,'foobar');

--delimiter $

begin not atomic

  declare i int default 0;

  declare rnum int default -1;

  declare msg varchar(1024) default '';

  declare err int default -1;

  while i < @@warning_count

  do

    set i = i + 1;

    get diagnostics condition i rnum = error_index, msg = message_text, err = mysql_errno;

    select i, rnum, msg, err;

  end while;

end $

--delimiter ;

get diagnostics condition 1 @rnum = error_index, @msg = message_text, @err = mysql_errno;

select @rnum, @msg, @err;

get diagnostics condition 2 @rnum = error_index, @msg = message_text, @err = mysql_errno;

select @rnum, @msg, @err;

+------+------+---------------------------------------+------+

| i    | rnum | msg                                   | err  |

+------+------+---------------------------------------+------+

|    1 |    1 | Duplicate entry '1' for key 'PRIMARY' | 1062 |

+------+------+---------------------------------------+------+

1 row in set (0.001 sec)

+------+------+----------------------------------------+------+

| i    | rnum | msg                                    | err  |

+------+------+----------------------------------------+------+

|    2 |    1 | Data truncated for column 'a' at row 3 | 1265 |

+------+------+----------------------------------------+------+

1 row in set (0.001 sec)

MariaDB [test]> get diagnostics condition 1 @rnum = error_index, @msg = message_text, @err = mysql_errno;

Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> select @rnum, @msg, @err;

+-------+---------------------------------------+------+

| @rnum | @msg                                  | @err |

+-------+---------------------------------------+------+

|     2 | Duplicate entry '1' for key 'PRIMARY' | 1062 |

+-------+---------------------------------------+------+

1 row in set (0.000 sec)

MariaDB [test]> get diagnostics condition 2 @rnum = error_index, @msg = message_text, @err = mysql_errno;

Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> select @rnum, @msg, @err;

+-------+----------------------------------------+------+

| @rnum | @msg                                   | @err |

+-------+----------------------------------------+------+

|     3 | Data truncated for column 'a' at row 3 | 1265 |

+-------+----------------------------------------+------+

1 row in set (0.000 sec)