mysql 导出表结构操作

 SELECT column_name AS '列名'
     , CASE
       WHEN data_type = 'varchar' || data_type = 'char' THEN
         concat(data_type, '(', character_maximum_length, ')')
       WHEN data_type = 'int' THEN
         concat(data_type, '(', numeric_precision, ')')
       WHEN data_type = 'double' || data_type = 'decimal' || data_type = 'float' THEN
         concat(data_type, '(', numeric_precision, ',', numeric_scale, ')')
       ELSE
         data_type
       END AS '数据类型'
     , CASE
       WHEN is_nullable = 'YES' THEN
         '是'
       ELSE
         '否'
       END AS '是否允许非空'
     , column_default AS '默认值'
     , column_comment AS '备注'


FROM
  Information_schema.columns
WHERE
  table_Name = 'msgm_zdxx'
  AND TABLE_SCHEMA = 'cbs_db'