As Jay said, it's either a permission issue or the file already exists.
MySQL will not overwrite a file that already exists.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 21, 2004 3:35 PM
To: Mysql General (E-mail)
Subject: RE: SELECT... INTO OUT
I am using SELECT statements to write some files via INTO OUTFILE. This has
been working fine, but now I have the need to export the column headings
from the MySQL tables along with the column contents. Is this possible? If
so, how?
Ex.
SELECT stock, vin, color, mileage, price, cylinders, p
