RE: select into the same outfile repetitively

[snip] Sometimes I need to execute 'select * into outfile '/tmp/t1.out' more than 1 times before I get the right result. But once mysql succeeds in writing t1.out, it does not overwrite it if the same sql command is executed for the 2nd time unless t1.out is removed. Is there anyway to c

select into the same outfile repetitively

Hi, mysql Gurus, Sometimes I need to execute 'select * into outfile '/tmp/t1.out' more than 1 times before I get the right result. But once mysql succeeds in writing t1.out, it does not overwrite it if the same sql command is executed for the 2nd time unless t1.out is removed. Is there any