There is no option to do this to my knowledge. However, this would be a quick workaround: - TRUNCATE TABLE <table>; # clears table completely, akin to doing DROP/CREATE TABLE - INSERT INTO <table> SELECT .. FROM ..;
On Mon, 16 Apr 2007, Amer Neely wrote: > > 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 > > :) Thanks, but you missed the part about '.. an existing file..'. I'm > hoping there is an option for the SELECT INTO to do this. I'm doing some > extensive testing and it's getting tiresome having to delete a file each > time I run the test. > > -- > Amer Neely > w: www.softouch.on.ca/ > Perl | MySQL programming for all data entry forms. > "We make web sites work!" > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]