Mysql中使用SQL语句命令导出到Excel文件

方法一

php教程用mysql的命令和shell

select * into outfile ‘./bestlovesky.xls’ from bestlovesky where 1 order by id desc limit 0, 50;

方法二 把bestlovesky.xls以文本方式打开,然后另存为,在编码选择ansi编码,保存

echo “select id,name from bestlovesky where 1 order by id desc limit 0, 50;”| /usr/local/mysql/bin/mysql -h127.0.0.1-uroot -p123456 > /data/bestlovesky.xls

19596979899114
 
Copyright © 2008-2021 lanxinbase.com Rights Reserved. | 粤ICP备14086738号-3 |