SHOW COLUMNS FROM <tablename> gives all the information of the columns in a table, except
How to extract
Comments information? I know the way to extract the information from INFORMATION SCHEMA, but how to combine the result in a single result set?
You can use the query
SHOW FULL COLUMNS FROM <tablename>
If you don’t want to use
Answered By – Nicola Cossu
Answer Checked By – Mildred Charles (BugsFixing Admin)