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
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?
not in the same query, no
This topic is now archived. It is frozen and cannot be changed in any way.