1、通过如下sql查询出数据字典信息
SELECT
table_schema AS '数据库',
TABLE_NAME AS '表名',
COLUMN_NAME AS '字段名',
COLUMN_TYPE AS '数据类型',
IS_NULLABLE AS '允许为空',
EXTRA AS 'PK',
COLUMN_COMMENT AS '字段说明'
FROM
information_schema.COLUMNS
WHERE
table_schema IN ( "数据库名" );
2、导出结果为txt.并将字段分隔符设置为逗号。
3、运行下列代码,将上一步导出的txt转为md格式。
import lombok.Data;
import java.io.IOException;
import java.nio.charset.Charset;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.util.*;
import java.util.stream.Collectors;
import java.util.stream.Stream;
public class ProcessMsqlDD {
public static void main(String[] args) {
try (Stream<String> lines =
Files.lines(Paths.get("C:\\Users\\wafer\\Desktop\\测试查询.txt"), Charset.defaultCharset())) {
TreeMap<String, TreeMap<