Using DBExportDoc V1.0 For MySQL to automatically generate database table structure documents

For DBA or developers, how to standardize your database table structure documents is a very important thing. But when your library and your watch are overwhelming, you will have a headache.

Recommend a tool, DBExportDoc V1.0 For MySQL (MySQL database table structure exporter).

Introduction:

DBExportDoc V1.0 For MySQL is a gadget developed by using the office feature VBA, which can be used to export the data structure of any database or table on the native MySQL. But it's not something you install all the way from next to finish and you can use it right away.

There are two points to pay attention to:

First, you need to make sure that mysql-connector-odbc (ODBC data Source Manager) is installed on your system.

MySQL Connector/ODBC is the ODBC driver for the MySQL database, which can be downloaded from mysql's website (http://dev.mysql.com/downloads/connector/odbc/). After installing this program, you can access MySQL through ODBC.

Second, after installing ODBC, you need to configure the connection to the mysql database in Control Panel-> Administrative tools-> data sources (ODBC).

Finally, you can use this software by opening the DBExportDoc V1.0 For MySQL.doc file and enabling macros.

The interface above does not appear because macros are not enabled without your word

Just click Export.

The exported database table structure description document even the header and directory have done for you!