The case is simple: You have an mysql database where you have only 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.)