# 查找在那个表并生成 字段名 SQL
SELECT TABLE_SCHEMA, TABLE_NAME, concat('SELECT ',
group_concat(COLUMN_NAME ORDER...BY ORDINAL_POSITION SEPARATOR ', ' )
, ' FROM ' , TABLE_SCHEMA, '...ORDINAL_POSITION SEPARATOR ', ')) AS COLUMN_NAMES
FROM information_schema.COLUMNS WHERE 1=1
AND TABLE_NAME...BY ORDINAL_POSITION SEPARATOR ',\n')
, '\nWHERE col=val;')AS SQLStr
FROM information_schema.COLUMNS...ELSE concat_ws(' AS ', COLUMN_NAME, COLUMN_COMMENT)
END
ORDER BY ORDINAL_POSITION SEPARATOR ',