[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 
change it or somehow have mysql just write it once more?
       Hope I am clear. Thanks a lot for help
[/snip]

>From http://dev.mysql.com/doc/mysql/en/SELECT.html

"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. The file cannot already
exist, which among other things prevents files such as `/etc/passwd' and
database tables from being destroyed. The SELECT ... INTO OUTFILE
statement is intended primarily to let you very quickly dump a table on
the server machine."

You would have to do something with your programming language

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to