Hi,

Is there a reason why, if I can

LOAD DATA LOCAL INFILE 'file' INTO TABLE fred;

why I can't

SELECT * INTO LOCAL OUTFILE '/tmp/file.txt' FROM fred

I know the data has to travel to the client, but it would make scripting
easier!

Quentin Bennett
Transport Systems Division
Infinity Solutions 
web http:\\www.infinity.co.nz
mailto:[EMAIL PROTECTED]
Phone : +64 9 358 9720
Fax : +64 9 309 4142


The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to