On Wed, May 26, 1999 at 01:27:23AM +0200, Stan P. van de Burgt wrote:
> It would be nice to be able to issue a command in the mysql
> client to import or (more important) export a file, and that
> the file is opened by the client and then used by the server.
Most of these can be done via:
mysql --quick -e 'SELECT foo FROM bar WHERE baz' database > outfile
and
mysql database < infile
(or maybe)
perl -pe 's/X/Y/; s/M/N/g;' infile | mysql database
It may not be quite as convenient, but it works well.
Tim