HI, Just add this at the end of your command "fields termininated by ','" like below,
select * from ae_a222 where ano=2009 and dia_juliano between '1' and '365' into outfile "C:\\Documents and Settings\\rbastos\\Meus documentos\\teste.txt" fields termininated by ',' ; - Partha www.mafiree.com ----- Original Message ---- From: Rodrigo A. de Brito Bastos <rodrigo...@gmail.com> To: mysql@lists.mysql.com Sent: Fri, 8 January, 2010 6:00:19 PM Subject: Export into txt file (comma delimited) Hey guys! Is there a way to export a table into a txt file but delimited *with comma*? I'm using this expression: select * from ae_a222 where ano=2009 and dia_juliano between '1' and '365' into outfile"C:\\Documents and Settings\\rbastos\\Meus documentos\\teste.txt" Thanks in advance! Rodrigo A. de Brito Bastos rodrigo...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org