/mysqlTableStatement

MySQL Table Statement Report Generator tool

Primary LanguagePythonGNU General Public License v2.0GPL-2.0

MySQL Table Statement

MySQL Table Statement Report Generator tool

Requirement

  • jinja2

pip install jinja2

  • mysql.connector 1.x

wget http://dev.mysql.com/get/Downloads/Connector-Python/mysql-connector-python-1.1.6.tar.gz tar zxvf mysql-connector-python-1.1.6.tar.gz cd mysql-connector-python-1.1.6 python setup.py install

Arguments

  • help

-u --user: mysql user id -p --password: mysql user password -h --host: mysql host ip address -D --database: database schema name -r --report: result output path

run script

  • Example

report.py -u mysql_user_id -p password -h host_ip -D schema_name -r /path/to/report.html

Report Result

Schema Name

Table Name

Table comment

Column Type Not Null Primary Key Auto Increment Default Comment
id int(11) No Pri No None index