Paul DuBois wrote:
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 on
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 manua
not a
TABLE. Perhaps a better Subject should have been 'How to overwrite
existing file with SELECT .. INTO OUTFILE'.
I think I'll end up writing a Perl script to do this.
On Mon, 16 Apr 2007, Amer Neely wrote:
At 08:14 AM 4/13/2007, Amer Neely wrote:
I'm using MySQL 5.0
There is no option to do this to my knowledge. However, this would be a
quick workaround:
- TRUNCATE TABLE ; # clears table completely, akin to doing
DROP/CREATE TABLE
- INSERT INTO SELECT .. FROM ..;
On Mon, 16 Apr 2007, Amer Neely wrote:
> > At 08:14 AM 4/13/2007, Amer Neely wrote:
> >> I'm
At 08:14 AM 4/13/2007, 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,
o:
Sent: Sunday, April 15, 2007 8:36 AM
Subject: Re: How to overwrite existing file with SELECT .. INTO?
At 08:14 AM 4/13/2007, 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'
At 08:14 AM 4/13/2007, 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, b
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.
--
Amer