RE: export result from select statement

2011-01-10 Thread Jerry Schwartz
>-Original Message- >From: Michael Dykman [mailto:mdyk...@gmail.com] >Sent: Sunday, January 09, 2011 3:02 PM >To: LAMP; mysql@lists.mysql.com >Subject: Re: export result from select statement > >I second Jerry's recommendation. It always works like a charm for

RE: export result from select statement

2011-01-10 Thread Jerry Schwartz
>-Original Message- >From: LAMP [mailto:l...@afan.net] >Sent: Sunday, January 09, 2011 9:46 PM >To: mysql@lists.mysql.com >Subject: Re: export result from select statement > >maybe it's "clear" to other but it's pretty unclear. >#mysql -userna

Re: export result from select statement

2011-01-09 Thread Yogesh Kore
gt;> E-mail: je...@gii.co.jp >> Web site: www.the-infoshop.com >> >> >> >>> -Original Message- >>> From: LAMP [mailto:l...@afan.net] >>> Sent: Saturday, January 08, 2011 6:05 PM >>> To: mysql@lists.mysql.com >>> Subject: export

Re: export result from select statement

2011-01-09 Thread LAMP
the-infoshop.com -Original Message- From: LAMP [mailto:l...@afan.net] Sent: Saturday, January 08, 2011 6:05 PM To: mysql@lists.mysql.com Subject: export result from select statement Hi guys, I wonder how to store to csv or txt file result from SELECT query? not a whole table nor database

Re: export result from select statement

2011-01-09 Thread LAMP
Eric Bergen wrote: select into outfile is the correct way. What do you mean by doesn't work? Does it give you an error? It was an issue with permissions :-) Thanks On Sat, Jan 8, 2011 at 3:04 PM, LAMP wrote: Hi guys, I wonder how to store to csv or txt file result from SELECT query? n

Re: export result from select statement

2011-01-09 Thread Michael Dykman
foshop.com > >>-Original Message- >>From: LAMP [mailto:l...@afan.net] >>Sent: Saturday, January 08, 2011 6:05 PM >>To: mysql@lists.mysql.com >>Subject: export result from select statement >> >>Hi guys, >>I wonder how to store to csv or txt file resu

RE: export result from select statement

2011-01-09 Thread Jerry Schwartz
.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >-Original Message- >From: LAMP [mailto:l...@afan.net] >Sent: Saturday, January 08, 2011 6:05 PM >To: mysql@lists.mysql.com >Subject: export result from select statement > >Hi guys, >I won

Re: export result from select statement

2011-01-08 Thread Eric Bergen
select into outfile is the correct way. What do you mean by doesn't work? Does it give you an error? On Sat, Jan 8, 2011 at 3:04 PM, LAMP wrote: > Hi guys, > I wonder how to store to csv or txt file result from SELECT query? not a > whole table nor database. Just results from SELECT query. > Usua

export result from select statement

2011-01-08 Thread LAMP
Hi guys, I wonder how to store to csv or txt file result from SELECT query? not a whole table nor database. Just results from SELECT query. Usually I use MySQL Query Browser and Export feature, but in this case I don't have access with MySQL Query Browser. Though, I have a command line acces