mysql 表结构文档整理
SELECT
c.ORDINAL_POSITION,
c.COLUMN_NAME
FROM
information_schema.`COLUMNS` c
WHERE
c.TABLE_SCHEMA = 'database'
AND c.TABLE_NAME = 'tablename'
SELECT
c.ORDINAL_POSITION,
c.COLUMN_NAME
FROM
information_schema.`COLUMNS` c
WHERE
c.TABLE_SCHEMA = 'database'
AND c.TABLE_NAME = 'tablename'