What is the command to see the warning messages?

This question asks about how to view warning messages in MySQL.
Warning messages are generated when MySQL encounters a potential issue during a query, but the query is still able to execute.

Let's look at the options:

Option A: DISPLAY WARNINGS
This is not a valid MySQL command.

Option B: DISP WARNINGS
This is not a valid MySQL command.

Option C: DISP WARNING
This is not a valid MySQL command.

Option D: SHOW WARNINGS
This is the correct command to view warning messages in MySQL. It will display a list of any warning messages generated by the last query.

So the answer is Option D: SHOW WARNINGS.