List:General Discussion« Previous MessageNext Message »
From:ishaq gbola Date:January 5 2010 1:42pm
Subject:Re: Exporting the result of a Query into excel
View as plain text  
Am running windows on my local host and Redhat linux on the remote server, I have no mysql
client on local host. TAC for the NMS using the database adviced me not to use a
msqlclient for it, that it could break the database??? 

--- On Tue, 5/1/10, sureshkumarilu@stripped <sureshkumarilu@stripped> wrote:

From: sureshkumarilu@stripped <sureshkumarilu@stripped>
Subject: Re: Exporting the result of a Query into excel
To: "ishaq gbola" <ishaqgbo@stripped>, mysql@stripped
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
Sent from BlackBerry® on Airtel

-----Original Message-----
From: ishaq gbola <ishaqgbo@stripped>
Date: Tue, 5 Jan 2010 13:31:59 
To: <mysql@stripped>
Subject: Re: Exporting the result of a Query into excel

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 <lists@stripped> wrote:

From: Jay Ess <lists@stripped>
Subject: Re: Exporting the result of a Query into excel
To: "mysql@stripped >> Mysql" <mysql@stripped>
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 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.anjanesh.net/2007/12/export-mysql-data-to-excel-compatible.html


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

To unsubscribe:    http://lists.mysql.com/mysql?unsub=1









      
Thread
Exporting the result of a Query into excelishaq gbola5 Jan
  • Re: Exporting the result of a Query into excelJay Ess5 Jan
    • Re: Exporting the result of a Query into excelishaq gbola5 Jan
      • Re: Exporting the result of a Query into excelJay Ess5 Jan
        • Re: Exporting the result of a Query into excelishaq gbola5 Jan
          • Re: Exporting the result of a Query into excelsureshkumarilu5 Jan
      • Re: Exporting the result of a Query into excelsureshkumarilu5 Jan
      • Re: Exporting the result of a Query into excelJim Lyons5 Jan
        • Re: Exporting the result of a Query into excelCarsten Pedersen5 Jan
          • Re: Exporting the result of a Query into excelLawrence Sorrillo5 Jan
          • Re: Exporting the result of a Query into excelJim Lyons5 Jan
  • Re: Exporting the result of a Query into excelJim Lyons5 Jan
  • RE: Exporting the result of a Query into excelJason Trebilcock6 Jan
Re: Exporting the result of a Query into excelishaq gbola5 Jan
  • Re: Exporting the result of a Query into excelsureshkumarilu5 Jan
  • Re: Exporting the result of a Query into excelMichael Dykman5 Jan