How to export mysql table structure to excel

The requirements are as follows

Export the table structure, field comment information, table name, etc. This can be achieved without using third-party tools.

SELECT
 TABLE_NAME table name,
 COLUMN_NAME column name,
 COLUMN_TYPE data type,
 DATA_TYPE field type,
 CHARACTER_MAXIMUM_LENGTH length,
 IS_NULLABLE Is it empty?
 COLUMN_DEFAULT default value,
 COLUMN_COMMENT Comments FROM
 INFORMATION_SCHEMA.COLUMNS
where
-- developerclub is the database name. You only need to change it to the database you want to export the table structure. table_schema = 'developerclub' 

The effect is as follows

I'm too lazy to change them one by one, the effect has been achieved.

The above is the details of how to export the table structure of MySQL to Excel. For more information about exporting the table structure of MySQL to Excel, please pay attention to other related articles on 123WORDPRESS.COM!