mysql获取字段信息

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

 SELECT

   TABLE_SCHEMA AS `databaseName`,

   TABLE_NAME AS `tableName`,

   COLUMN_NAME AS `columnName`,

   DATA_TYPE AS `columnType`,

   COLUMN_COMMENT AS `columnComment`

 FROM

   `information_schema`.`COLUMNS`

 WHERE `TABLE_SCHEMA` = '数据库名称'

   AND `TABLE_NAME` = '表名' ;

其中 TABLE_SCHEMA 和 TABLE_NAME 分别改成对应数据库和表名即可

结果：

atabaseName   tableName  columnName  columnType  columnComment

------------  ---------  ----------  ----------  ---------------

km_jobs2018   web_sms    id          int

km_jobs2018   web_sms    receiveNo   varchar     接收号码

km_jobs2018   web_sms    content     varchar     短信内容

km_jobs2018   web_sms    sendId      int         发送人Id

km_jobs2018   web_sms    sendName    varchar     发送姓名

km_jobs2018   web_sms    sendDate    datetime    发送时间

km_jobs2018   web_sms    sendResult  varchar     发送结果

km_jobs2018   web_sms    sendType    varchar     短信类型