SELECT
c.ORDINAL_POSITION,
c.COLUMN_NAME
FROM
information_schema.`COLUMNS` c
WHERE
c.TABLE_SCHEMA = 'database'
AND c.TABLE_NAME = 'tablename'
mysql 表结构文档整理
于 2019-03-04 16:10:42 首次发布
SELECT
c.ORDINAL_POSITION,
c.COLUMN_NAME
FROM
information_schema.`COLUMNS` c
WHERE
c.TABLE_SCHEMA = 'database'
AND c.TABLE_NAME = 'tablename'