mysql查询表字段信息

bolin_

于 2014-11-20 13:24:29 发布

阅读量535

点赞数 1

CC 4.0 BY-SA版权

分类专栏： mysql 文章标签： mysql column

本文链接：https://blog.youkuaiyun.com/wangbailin2009/article/details/41311507

mysql 专栏收录该内容

6 篇文章

订阅专栏

SELECT column_name AS columnName,
       column_type AS columnType,
       is_nullable AS nullable,
       column_default AS columnDefault,
       column_comment AS columnComment,
       IF(column_key = 'PRI', '主键','') AS columnKey
 FROM information_schema.`COLUMNS` WHERE table_name='dp_rpt_jcbx0401' AND table_schema=DATABASE()
 ORDER BY ordinal_position ASC