mysql command to export excel

mysql command to export excel

Step 1: Execute the command

select * from tablename into outfile ‘d:/test.xls’; or select * into outfile ‘d:/test.xls’ from tablename a where column_1 = ?;

Step 2: Open test.xls in the form of text, and select ‘ANSI’ as the encoding when saving. This step mainly solves the problem of garbled characters

Was this article helpful?

Related Articles

Leave A Comment?

You must be logged in to post a comment.