When working with stored routines, these details are available:
+ The affected –rows count
+ The number of conditions that occurred
+ The condition information, such as the error code and message
Where can you find these defaults?
A.
In the Handler area, defined in the DECLARE handler_action HANDLER block in a stored
routine
B.
In the Signal area, which is set with the help of the SIGNAL statement in a stored routine
C.
In the Diagnostics area, part, of which can be stored in user-defined or routine variables
D.
In the Error area, which can be accessed with the help of the SHOW ERRORS statement
C.
https://dev.mysql.com/doc/refman/5.6/en/diagnostics-area.html
Statement information, such as the number of conditions that occurred or the affected-rows count.
Condition information, such as the error code and message. If a statement raises multiple conditions, this part of the diagnostics area has a condition area for each one. If a statement raises no conditions, this part of the diagnostics area is empty.
C
C