export_mysql_table_with_markdown_table.awk

#! /bin/sh
# awk export mysql table info with markdown table
awk '
BEGIN{
}
{
    if($0~/CREATE/){
        gsub("`", "", $6)
        print "### "$6
        print "\n"
        print "|字段名|类型|注释|"
        print "|--------|---------|------------|"
    }else{
        if($0 ~ /^)/){
        print "\n"
    }
    }
    if($0 ~ /^[ ]+`/){
        # print $0;
        gsub("`", "", $0)
        if($(NF-1) ~/COMMENT/){
            sub(/,$/, "", $NF)
            print "| "$1" | " $2" | " $NF "|"
        }else{
            print "| "$1" | " $2" | |"
        }
    }
}
END{
 
}
'