SELECT subqueries

Old Pedant · September 22nd, 2010, 02:12 PM

I haven't use OUTFILE with Windows, only with Linux.

But in Windows, shouldn't the path use \ and *NOT* / ???

f:\result.xls

And of course you will have to give the right permissions to f:

And, finally, I don't see how that creates an ".xls" file. That will just create a text file, not a proper CSV file, won't it??

Wenggo · September 22nd, 2010, 10:27 PM

Thanks Old Pedant, I am not fimiliar with it, any best solution you had, in order make downloaded to EXCEL format. Tried will all technique, remain failed

Old Pedant · September 23rd, 2010, 02:00 PM

Well, a CSV file normally has the format

Code:

"id","product","quantity"
73,"basket",17
33,"wheel",2

So clearly you could write your SQL SELECT to produce that. Tedious, but possible.

Personally, I'd use PHP or ASP or even VB to read the data and convert it to CSV, but that's up to you.

Wenggo · September 23rd, 2010, 06:03 PM

Ok thanks, how should I code it it, want to try and convert it to EXCEL, i do need to produce in EXCEL format.

Regards.

Old Pedant · September 23rd, 2010, 08:32 PM

You can't produce Excel format easily. The best compromise is to produce ".csv" format (which I showed in post #13), which Excel *can* read.

Wenggo · September 23rd, 2010, 09:23 PM

Ermm..thanks for the solution, do we have other alternative instead of using temporary table in Mysql 4.01 as your example shown before...

Anyway I do thanks a lot for your helping and advice, may god bless.