Export into txt file (comma delimited)

--001636417667f25417047ca65a20
Content-Type: text/plain; charset=ISO-8859-1

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
rodrigoabb@gmail.com

--001636417667f25417047ca65a20--

Re: Export into txt file (comma delimited)

----- Rodrigo A. de Brito Bastos wrote >Hey guy=
s!=0A>=0A>Is there a way to export a table into a txt file but delimited *w=
ith comma*?=0A> Hello!=0Ayou can use this syntax: select * from a=
e_a222=0Awhere ano=3D2009 and dia_juliano between '1' and '365'=0Ainto outf=
ile"C:\\Documents and Settings\\rbastos\\Meus=0Adocumentos\\teste.txt" fiel=
ds terminated by ',' =0A


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Export into txt file (comma delimited)

HI, Just add this at the end of your command "fields termininated by '=
,'" like below, select * from ae_a222=0Awhere ano=3D2009 and dia_julia=
no between '1' and '365'=0Ainto outfile "C:\\Documents and Settings\\rbasto=
s\\Meus=0Adocumentos\\teste.txt" fields termininated by ',' ; - Partha=
=0Awww.mafiree.com =0A----- Original Message ----=0AFrom: Rodrig=
o A. de Brito Bastos =0ATo: mysql@lists.mysql.com=0AS=
ent: Fri, 8 January, 2010 6:00:19 PM=0ASubject: 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: sele=
ct * from ae_a222=0Awhere ano=3D2009 and dia_juliano between '1' and '365'=
=0Ainto outfile"C:\\Documents and Settings\\rbastos\\Meus=0Adocumentos\\tes=
te.txt" Thanks in advance! Rodrigo A. de Brito Bastos=0Arodrigoab=
b@gmail.com=0A

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg