DUMPFILE

[tgavin]

I have several fields, one of which is a BLOB. I want to SELECT the fields and return the results to the browser, and then dump the contents of the BLOB into a file on the server. I'm struggling with how to do this in one query. The on_linear_array field is the BLOB.

SELECT
id
,model_type
,on_linear_array
INTO DUMPFILE
'dump.txt'
FROM station

[r937]

return the results to the browser??

isn't there an application language in between mysql and the browser? like php or something?

[tgavin]

Ha! Yes, Mr. Literal, I'll be using PHP to print the results to the browser.

[r937]

okay, so php retrieves the data from the database and saves the blob to the file

i don't do php or i'd help you further

[tgavin]

The query is the problem; it's putting all of the results into the file. I figured I'd written it incorrectly. Hmmm...