MySQL 表结构生成 Markdown 文档

源码方式安装

git clone https://github.com/alicfeng/mysql_markdown.git
cd mysql_markdown

安装依赖包
go get "github.com/go-sql-driver/mysql" 使用中国加速

export GOPROXY=https://goproxy.cn
go get -u github.com/go-sql-driver/mysql

编译到/usr/local/bin/mysql_markdown

go build -o /usr/local/bin/mysql_markdown mysql_markdown.go
chmod +x /usr/local/bin/mysql_markdown

使用

# 帮助函数
$ mysql_markdown -h
flag needs an argument: -h
Usage: mysql_markdown [options...]
--help  This help text
-h      host.     default 127.0.0.1
-u      username. default root
-p      password. default root
-d      database. default mysql
-P      port.     default 3306
-c      charset.  default utf8
-o      output.   default current location
-t      tables.   default all table and support ',' separator for filter, every item can use regexp
-l      language. default cn,support: cn,en
# 指定数据库
$ mysql_markdown -h 124.221.104.202 -u root -p  123456 -d wiki
llangguage:cnconnecting to MySQL to export markdown document file.
 100% |███████████████████████████████████████████████████████████████████████████████████████████| (4/4, 14 it/s)
convert to document finished in wiki_20230301_142215.md