Exporting and overwriting file

2002-10-01 Thread Carter, Steve


Hi,

I am trying to export a query into a .CSV file using SELECT ... OUTFILE at
the command prompt.


It works ok the first time but all subsequent runs give a 1086 error - File
already exists.

I have to use the command prompt vs. a GUI as I am running this in a .cgi
script.  Is there any way that I overwrite the file each time I export.

Thanks


Steve Carter
 

-
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




Re: Exporting and overwriting file

2002-10-01 Thread gerald_clark

No.
How would the server know if you had used the previous output file?
As a matgter of fact, since it is still there, I guess you didn't.

Have your cgi script move it.

Carter, Steve wrote:

Hi,

I am trying to export a query into a .CSV file using SELECT ... OUTFILE at
the command prompt.


It works ok the first time but all subsequent runs give a 1086 error - File
already exists.

I have to use the command prompt vs. a GUI as I am running this in a .cgi
script.  Is there any way that I overwrite the file each time I export.

Thanks


Steve Carter
  




-
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