【无标题】查询表结构示例

查询表结构

SELECT table_schema '库名',TABLE_NAME '表名',column_name '列名',ordinal_position '序号',COLUMN_DEFAULT '默认值'  FROM `information_schema`.`COLUMNS` WHERE TABLE_SCHEMA='pms_test' and column_name = 'hotel_id' ORDER BY ORDINAL_POSITION;