write query results to a file

chlorisw · #1 (**permalink**) 10-17-03, 16:21

How can I write query results to a file using a stored procedure?

gnet · #2 (**permalink**) 10-17-03, 18:17

If you're not using 4.1 you can't ... and even if you were, I wouldn't know how.

But you could do:

Code:

SELECT <select_options>
INTO OUTFILE '/path/file.txt'
FROM TABLE

ika · #3 (**permalink**) 10-22-03, 07:11

Quote:

Originally posted by chlorisw
How can I write query results to a file using a stored procedure?

MySQL does not supporting stored procedures. Stored procedures are planed from 5.0 version...