The case is simple: You have a MySQL database where you have only an SQL query interface and you want to know the database structure with queries. You can list tables with
show tables; command, but how do you see the individual column names?
SELECT statement shows
Empty set if no data is present and can NOT be thus used.)