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

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