Mysql outfile to current working directory?

Question

Is there a way I can make the OUTFILE statement in a .sql file point to the path of the current working directory of the .sql file itself, without manually specifying an absolute path name? As it is now, the default location is the data directory of the schema that I'm working with (ie. C:\progra~1\mysql\etc\etc).

Thanks!

Answer 1

Seems like scripting would be your best bet on this. Using Perl or PHP to generate the query with the outfile in cwd.