Which two can be used to obtain information stored in the Diagnostics Area?
A.
SHOW WARNINGS
B.
GET DIAGNOSTICS CONDITION 1 @errno=MYSQL_ERRNO, @msg
=MESSAGE_TEXT;
SELECT @errno, @msg;
C.
SELECT ERRNO, MESSAGE_TEXT FROM
INFORMATION_SCHEMA.DIAGNOSTICS_AREA WHERE CONDITION=1
D.
SHOW GLOBAL STATUS LIKE ‘Diagnostics’
Explanation:
Reference:
http://dev.mysql.com/doc/refman/5.6/en/diagnostics-area.html
A and B
A and B
https://dev.mysql.com/doc/refman/5.6/en/diagnostics-area.html
The diagnostics area can be examined with GET DIAGNOSTICS to extract specific items, or with SHOW WARNINGS or SHOW ERRORS to see conditions or errors.
A B
A B