获取数据库字段描述等信息的SQL

赵小赵小赵赵

于 2020-06-03 16:22:10 发布

阅读量289

点赞数

本文链接：https://blog.youkuaiyun.com/zmq594706413/article/details/106527127

版权

SET @rownum = 0 ;

SELECT 
  @rownum := @rownum + 1 AS rownum,
  COLUMN_NAME AS 列名,
  (
    CASE
      WHEN IS_NULLABLE = 'YES' 
      THEN '是' 
      ELSE '否' 
    END
  ) AS 是否为空,
  COLUMN_COMMENT AS 列的描述,
  COLUMN_TYPE AS 类型 
FROM
  information_schema.`COLUMNS` 
WHERE TABLE_SCHEMA = 
  (SELECT 
    DATABASE()) 
  AND TABLE_NAME = ('user') 
ORDER BY ORDINAL_POSITION ;