-- 导出某一确定数据库的确定表的相关信息
set @rownum=0;
SELECT
@rownum:=@rownum+1 AS 序号,
COLUMN_COMMENT AS 列的描述,
COLUMN_NAME AS 列名,
COLUMN_TYPE AS 类型 ,
CHARACTER_MAXIMUM_LENGTH as 长度,
(CASE WHEN IS_NULLABLE = 'YES' THEN '是' ELSE '否' END) AS 是否为空
FROM
information_schema.`COLUMNS`
WHERE
TABLE_SCHEMA = (select database()) AND
TABLE_NAME = ('t_draft_info') ORDER BY ORDINAL_POSITION ;
--导出确定数据库内的所有表的相关信息
set @rownum=0;
SELECT
@rownum:=@rownum+1 AS 序号 ,
t.TABLE_COMMENT AS 描述 ,
t.table_name AS 表名
FROM
information_schema.`TABLES` t
WHERE
t.TABLE_SCHEMA = (select database()) ORDER BY t.TABLE_NAME;
https://blog.csdn.net/m0_37890289/article/details/80003994(windows同时安装多个mysql8.0服务)