Hello Mike,
AFAIK,
What you have specified is applicable only for tables! But for file in
"Select ..into outfile", sure Exit handler is declared when we try to
overwrite an existing file!
Thanks
DEVI.G
----- Original Message -----
From: "mos" <[EMAIL PROTECTED]>
To: <[email protected]>
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' 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 Neely
Amer,
Why can't you do:
drop table if exists mynewtable;select .. into mynewtable
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.4.0/762 - Release Date: 4/15/2007
4:22 PM
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
