原生查 - 列名修改 - select col_name as "列名"

SELECT COLUMN_NAME as '列名' ,DATA_TYPE as '字段类型' ,COLUMN_TYPE as '长度加类型' FROM information_schema.`COLUMNS` where TABLE_SCHEMA like '库名' and TABLE_NAME like '表名' ORDER BY ordinal_position;

SELECT COLUMN_NAME as '列名' ,DATA_TYPE as '字段类型' ,COLUMN_TYPE as '长度加类型'
FROM information_schema.`COLUMNS`
where
TABLE_SCHEMA like '库名'
and
TABLE_NAME like '表名'
ORDER BY ordinal_position;

ORDER BY ordinal_position;按照表顺序排序