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
Leave A Comment?
You must be logged in to post a comment.