List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:May 26 1999 12:56am
Subject:Re: ABOUT LOAD DATA INFILE
View as plain text  
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
Thread
ABOUT LOAD DATA INFILEEduardo Oviedo Ocampo26 May
  • Re: ABOUT LOAD DATA INFILESasha Pachev26 May
  • Re: ABOUT LOAD DATA INFILEDarrell Shifflett26 May
  • Re: ABOUT LOAD DATA INFILEStan P. van de Burgt26 May
    • Re: ABOUT LOAD DATA INFILEThimble Smith26 May