Hello forums,

I was wondering if it's possible to query a row together with the COLUMN_NAME and COLUMN_NAME information schema

I have this:

Code:
SELECT COLUMN_NAME, COLUMN_COMMENT
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE table_name = 'my_table'
  AND table_schema = 'my_databse'
this returns the column name and column comment however I also want to retrieve the records in the table. Is this even possible?

Thanks