they're on separate machines, this seems the fastest method, but i'm not sure
if it's possible given my setup
[Fri, Feb 11, 2005 at 09:48:18AM +]
This one time, at band camp, Tom said:
> If your mysql server has access (or can have access) to the directory
> where you want to dump the file,
> i have a script that exports the result of a mysql query to a csv file
> suitable for downloading
>
> the code looks like
> $result = mysql_query("select * from user,mjp1,mjp2,mjp3,mjp4");
> while($row = mysql_fetch_array($result)) {
> $csv_output .= "$row[userid] $row[firstname] $row[lastname]\
If your mysql server has access (or can have access) to the directory
where you want to dump the file, you can just use the "SELECT INTO
OUTFILE FIELDS TERMINATED BY ','..." syntax as your query, which is very
fast.
Mirco Blitz wrote:
Hi,
Probably the Pear Excel_Syltesheet_Writer works for
Hi,
Probably the Pear Excel_Syltesheet_Writer works for you.
http://pear.php.net/package/Spreadsheet_Excel_Writer
I found out that it is faster with huge data sets on my system.
Greetings
Mirco
-Ursprüngliche Nachricht-
Von: Redmond Militante [mailto:[EMAIL PROTECTED]
Gesendet: Freitag
4 matches
Mail list logo
