> -Original Message-
> From: ishaq gbola [mailto:ishaq...@yahoo.co.uk]
> Sent: Tuesday, January 05, 2010 7:18 AM
> To: mysql@lists.mysql.com
> Subject: Exporting the result of a Query into excel
>
> Hi all,
>
> I would like to know if there is a tool or c
t;> Then use what transfer tool you have, ftp, scp, winscp, rsync to transfer
>> the file to another server.
>>
>> On Tue, Jan 5, 2010 at 7:31 AM, ishaq gbola wrote:
>>
>> Thanks a lot for that, but where does this file get saved in and how can
>>> i
&
wrote:
Thanks a lot for that, but where does this file get saved in and how
can i
copy it to my local host if the database is on a remote server
--- On Tue, 5/1/10, Jay Ess wrote:
From: Jay Ess
Subject: Re: Exporting the result of a Query into excel
To: "mysql@lists.mysql.com >>
n i
copy it to my local host if the database is on a remote server
--- On Tue, 5/1/10, Jay Ess wrote:
From: Jay Ess
Subject: Re: Exporting the result of a Query into excel
To: "mysql@lists.mysql.com >> Mysql"
Date: Tuesday, 5 January, 2010, 13:22
ishaq gbola wrote:
Hi all,
viced me not to use a msqlclient for it, that it could break the database???
>
> --- On Tue, 5/1/10, sureshkumar...@gmail.com wrote:
>
> From: sureshkumar...@gmail.com
> Subject: Re: Exporting the result of a Query into excel
> To: "ishaq gbola" , mysql@lists.mysql.com
> Da
: Jay Ess
> Subject: Re: Exporting the result of a Query into excel
> To: "mysql@lists.mysql.com >> Mysql"
> Date: Tuesday, 5 January, 2010, 13:22
>
> ishaq gbola wrote:
> > Hi all,
> >
> > I would like to know if there is a tool or command in myS
We have to use outfile with select stmt, not with show.
Suresh Kuna
Sent from BlackBerry® on Airtel
-Original Message-
From: ishaq gbola
Date: Tue, 5 Jan 2010 13:45:44
To:
Subject: Re: Exporting the result of a Query into excel
As test i tried this and I got the result below
mysql
: sureshkumar...@gmail.com
Subject: Re: Exporting the result of a Query into excel
To: "ishaq gbola" , mysql@lists.mysql.com
Date: Tuesday, 5 January, 2010, 13:37
Hi
What is the OS you are using on the remote and local server.
Is there a mysql client on local server?
Thanks
Suresh Kuna
r
'into outfile "trial.txt"' at line 1
mysql>
--- On Tue, 5/1/10, Jay Ess wrote:
From: Jay Ess
Subject: Re: Exporting the result of a Query into excel
To:
Cc: mysql@lists.mysql.com
Date: Tuesday, 5 January, 2010, 13:35
ishaq gbola wrote:
> Thanks a lot for that,
: sureshkumar...@gmail.com
Subject: Re: Exporting the result of a Query into excel
To: "ishaq gbola" , mysql@lists.mysql.com
Date: Tuesday, 5 January, 2010, 13:37
Hi
What is the OS you are using on the remote and local server.
Is there a mysql client on local server?
Thanks
Suresh Kuna
Hi
What is the OS you are using on the remote and local server.
Is there a mysql client on local server?
Thanks
Suresh Kuna
Sent from BlackBerry® on Airtel
-Original Message-
From: ishaq gbola
Date: Tue, 5 Jan 2010 13:31:59
To:
Subject: Re: Exporting the result of a Query into excel
ishaq gbola wrote:
Thanks a lot for that, but where does this file get saved in and how can i copy
it to my local host if the database is on a remote server
If you don't specify the absolute location it can be find in
"DATADIR/DatabaseName/". And after you located the file you have a
multit
Thanks a lot for that, but where does this file get saved in and how can i copy
it to my local host if the database is on a remote server
--- On Tue, 5/1/10, Jay Ess wrote:
From: Jay Ess
Subject: Re: Exporting the result of a Query into excel
To: "mysql@lists.mysql.com >> M
You can use the --xml option to the mysql command to get xnl output. You
can also get a tab-delimited output file that can be read into Excel (this
is what I usually do).
To get a tab-delimited file, you can use the --tab option of mysqldump or
start up the mysql program with the -sss option and
ishaq gbola wrote:
Hi all,
I would like to know if there is a tool or command in mySQL that allows one to
export the result of query into excel formart
select * from table into outfile "thefile.txt";
That can be imported into excel using CSV and using "TAB" as separator.
http://code.anjanes
Hi all,
I would like to know if there is a tool or command in mySQL that allows one to
export the result of query into excel formart
16 matches
Mail list logo
