I want to have a table in the mysql database data export to excel, using navicat 8 to export, export to excel but a text field, found that only a portion of each message data, truncated obviously, this is how to return a responsibility, what method can complete export to? I want to use the excel data import to essentially again, thank you all for the great god, help me.

CodePudding user response:

Once the length of the export is restricted the
When you handle the text field separately using stored procedures separate export
https://blog.csdn.net/bxf0011/article/details/1793113
This is the reference material

CodePudding user response:

Tested a, found a newline there will appear garbled

CodePudding user response:

Directly use the MYSQL command line tools to try,