I was wondering if it's possible to query a row together with the COLUMN_NAME and COLUMN_NAME information schema
I have this:
this returns the column name and column comment however I also want to retrieve the records in the table. Is this even possible?Code:
SELECT COLUMN_NAME, COLUMN_COMMENT
WHERE table_name = 'my_table'
AND table_schema = 'my_databse'