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
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
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
