sql生成想要的图表

SELECT
 @rank :=@rank + 1 AS 序号,
 a.*
FROM
 (
  SELECT
   COLUMN_NAME 字段名称,
   COLUMN_COMMENT 字段含义,
   CONCAT(
    DATA_TYPE,
    '(',
    CHARACTER_MAXIMUM_LENGTH,
    ')'
   ) 存储格式,
   IS_NULLABLE 是否为空
  FROM
   INFORMATION_SCHEMA. COLUMNS
  WHERE
   table_name = 't_dws_xzfy_flfvzx'
 ) a,
 (SELECT @rank := 0) b