Export the EXECL file using the MySQL command in Linux

This is not about using any programming language to implement this function, but using Shell and MySQL commands in Linux.

Java code

Echo "use test; select * from test order by id desc; "|/usr/local/mysql/bin/mysql-uXXXX-pXXXX -- default-character-set = utf8>/tmp/test.xls

Echo "use test; select * from test order by id desc; "|/usr/local/mysql/bin/mysql-uXXXX-pXXXX -- default-character-set = utf8>/tmp/test.xls

In order to prevent excel garbled characters from being opened in windows, you can use iconv to convert the code

Java code

Iconv-futf8-tgb2312 -otest2.xls test.xls