mysql按字母顺序获取表列名称

ANSI
INFORMATION_SCHEMA表（在本例中为INFORMATION_SCHEMA.COLUMNS）在MySQL中提供了更大的灵活性：

SELECt c.column_name  FROM INFORMATION_SCHEMA.COLUMNS c WHERe c.table_name = 'tbl_name'-- AND c.table_schema = 'db_name'    ORDER BY c.column_name