MySQL Database export csv garbled problem

First, the export of Chinese characters is garbled

1. Right click on the selected CSV file and select "Edit" in the popup menu, the system will use the text side

(notepad) to open the CSV file;

2. After opening the CSV file, make a "Save as" action, "encode" at the bottom of the popup screen, modify
Encoding method: from UTF-8 to ANSI. Save

3. After you open the Excel, the Chinese characters are displayed normally.

Second, the export content in a single row in a cell

Select database table--Right-click Properties--Backup/Export--export table data as---select CVS---Select the following "Change"--field--Variable length--field is terminated--enter comma , (This is the focus, otherwise the contents of the exported CSV file are all in one column, not the sub-fields) the following two options boxes are canceled.

Third, the number will become scientific counting method

Select Concat (' \ t ', a.name) from table

MySQL Database export csv garbled problem