[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]