SELECT TABLE_NAME,column_name,COLUMN_TYPE,COLUMN_COMMENT FROM information_schema.columns
WHERE table_schema = 'mcc'
AND table_name in (
select TABLE_NAME from information_schema.tables where table_schema='mcc')
WHERE table_schema = 'mcc'
AND table_name in (
select TABLE_NAME from information_schema.tables where table_schema='mcc')