1、mysql数据库导出成xls文件: mysql> select * from userinfo into outfile 'd:/user.xls'; Query OK, 1 row affected (0.02 sec) 转载于:https://blog.51cto.com/shouhouzhe/1376813