Shulou(Shulou.com)06/01 Report--

The methods are as follows:

Using the COLUMNS table information in the information_schema library of mysql to realize

For example, you need to export the data dictionary information of the ixinnuo_ zxpt library:

Open Navicat and select query-- > New query:

Select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where TABLE_SCHEMA='ixinnuo_zxpt'

In the upper right corner of the query results page, you can see a button with the export function. Click to select a variety of export formats, such as export to Excel, then you can select an Excel file (version 2007 or above).

Then follow the prompts to export Next step by step, as shown in the following figure:

The resulting Excel is as follows:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.