Steps to export the fields and related attributes of MySQL tables

Need to export the fields and properties of the table in the database, make a table and save it in Word

First find the library to be imported, enter sql on the query page

SELECT
 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
table_schema = 'database name'
AND
table_name = 'table name'

Get the result

Then copy it and you can copy the result

Note that what is copied is the content, without the header and table format. You need to draw a table of the appropriate size in Word and then paste the data into it.