mysql到csv而不使用mysql的INTO OUTFILE [英] mysql to csv without using INTO OUTFILE of mysql

问题描述

我需要将数据从mysql导出到具有列标题的csv文件，但我在服务器上没有文件许可权.还有其他方法吗?即使用php fwrite吗?还是fputcsv?

I need to export data from mysql to a csv file with column heading but i dont have file permission on the server. Is there any otherway to do it? i.e. using php fwrite? or fputcsv?

任何帮助都非常有用.

Any help will be much appriciate.

谢谢.

推荐答案

如果可以连接到MySQL服务器，则可以运行

If you can connect to the MySQL server, you can run the mysqldump utility, which is capable of generating CSV files. This is far easier than trying to come up with something yourself.

mysqldump --tab --fields-terminated-by="," --host=$SERVER --user=$USERNAME --password=$PASSWORD $DATABASE

这篇关于mysql到csv而不使用mysql的INTO OUTFILE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！