Option A

Option B

Option C

Option D

SHOW WARNINGS

GET DIAGNOSTICS CONDITION 1 @errno=MYSQL_ERRNO, @msg =MESSAGE_TEXT;

SELECT @errno, @msg;

SELECT ERRNO, MESSAGE_TEXT FROM INFORMATION_SCHEMA.DIAGNOSTICS_AREA WHERE CONDITION=1

SHOW GLOBAL STATUS LIKE ‘Diagnostics’

SELECT * may cause more data than you need to be read from disk if your application needs only some columns.

SELECT * causes more data than you need to be sent via the client/server protocol if your application needs only some columns.

SELECT * prevents the use of indexes, so a full table scan for every query.

SELECT *causes your application to depend on the columns present when you wrote it , so your application could break if the table structure changes.

SELECT * causes the statements to return all rows from the table.