Retrieve row table COLUMN_NAME and table COLUMN_COMMENT

Databases
1

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:

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

2

not in the same query, no