Results 1 to 2 of 2
Aug 25, 2012, 02:51 #1
Retrieve row table COLUMN_NAME and table COLUMN_COMMENT
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'