Which two can be used to obtain information stored in the Diagnostics Area?

Which two can be used to obtain information stored in the Diagnostics Area?

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



Leave a Reply 4

Your email address will not be published. Required fields are marked *