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

This article will explain in detail the methods of mysql export table fields and related properties for you. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

You need to export the fields and properties of the table in the database, make a table and save it to word.

First find the library you want to import and enter sql on the query page

SELECT COLUMN_NAME column name, COLUMN_TYPE data type, DATA_TYPE field type, CHARACTER_MAXIMUM_LENGTH length, whether IS_NULLABLE is empty, COLUMN_DEFAULT default value, COLUMN_COMMENT remarks FROM INFORMATION_SCHEMA.COLUMNSwheretable_schema = 'library name' ANDtable_name = 'table name'

Get the result

And then copy it, and you can copy the result.

Note that what is copied is the content, and there is no header and table format. You need to draw a table of the right size on word, and then paste the data on it.

On the mysql export table fields and related properties of the method to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.