At 10:14 AM -0400 4/13/07, Amer Neely wrote:
I'm using MySQL 5.0.21 and am trying to find out if it is possible
to overwrite an existing file when using a 'SELECT ... INTO' command
from the command line. Is there another parameter that can do this?
I've looked through the online reference manual, but found no
specific help there.
You cannot. This is a security feature. Otherwise, you might be able
to select into such files as /etc/password or /etc/shells.
From the manual:
The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the
selected rows to a file. The file is created on the server host, so
you must have the FILE privilege to use this syntax. file_name cannot
be an existing file, which among other things prevents files such as
/etc/passwd and database tables from being destroyed.
http://dev.mysql.com/doc/refman/5.0/en/select.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]