Re: table to output "into outfile"
The INTO OUTFILE syntax will create a filename, but not a directory.
Also note that when using relative paths, the file will be created relative to the current working directory of the thread in the MySQL Server, not the client. The current working directory is the data directory of the database you are using.
Say for example your MySQL data directory is "/var/lib/mysql" and your database name is "eCBOT". The relative path you gave will try to create a file "/var/lib/mysql/eCBOT/kss/lauradata.csv".
Regards,
Bill K.
Subject
Written By
Posted
Re: table to output "into outfile"
August 22, 2006 09:40AM
September 09, 2006 10:22AM
September 09, 2006 12:50PM
November 27, 2006 07:58PM
November 29, 2006 01:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.