MySQL table structure (with data type, field comment comment) exported to Excel

Method One:

1. With Navicat Premium, you can switch to any graphical client

SELECTcolumn_name column name, column_type data type, data_type field type, character_maximum_length length, is_nullable is empty, Column_default default value, Column_comment notes frominformation_schema. COLUMNSwhere  --ltmp the database nameTable_schema='ltmp'   andtable_name= 'A41'--A41 is the name of the table, and it will be replaced with the names of the tables you want to export--If you do not write, the default is to query out all the data in the table, which may not be able to tell exactly which fields are in which table, so it is recommended to write the name of the names to be exported

2. Query results:

3. Select Copy and paste into the ECEXL table

Method Two:

Using SQLyog Client Export

1. Creating the Database schema HTML

2. Select the table to export

3. Create HTML

4. The exported

MySQL table structure (with data type, field comment comment) exported to Excel