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 <[email protected]> To: [email protected] 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 [email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
