Specific field information of MySQL export table (detailed operation of Navicat client)

1 First execute the following statement

SELECT
	COLUMN_NAME  Name ,
	COLUMN_TYPE  data type ,
	IS_NULLABLE  Is it allowed to be empty ,
	COLUMN_KEY  Is it a primary key ,
	COLUMN_COMMENT  remarks  
FROM
	INFORMATION_SCHEMA.COLUMNS 
	WHERE-- dj_admin For database name , At that time, you only need to modify it to the database name of the table structure you want to export 
	table_schema = 'nan_music' 
	AND -- user Is the name of the watch , Then change to the name of the table you want to export 
--  If not , Data in all tables will be queried by default , In this way, you may not know which fields 
	table_name = 'dj_admin'
--z This is the table you specifically looked at 

2 The following results appear , Click the upper right corner to export the results

3 Click to export the current results

4 Choose the format you want

5 Move on to the next step

6 Add as needed , You can hook up , Keep going next step

7 Click Start

8 Click on the open We can find the file we want

9 Open the effect The first is txt Format , Later I derived it as excel Tabular , With a border , You can go straight to word Yes , It should be more commonly used , You can see that .

Copy directly to word in

It's more beautiful