您可以使用DESCRIBE:
DESCRIBE my_table;
或者在较新的版本中,您可以使用INFORMATION_SCHEMA:
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'my_database' AND TABLE_NAME = 'my_table';
或者您可以使用SHOW COLUMNS:
SHOW COLUMNS FROM my_table;
或者,要获取行中带有逗号的列名,请执行以下操作:
SELECT group_concat(COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'my_database' AND TABLE_NAME = 'my_table';