List:General Discussion« Previous MessageNext Message »
From:sureshkumarilu Date:January 5 2010 1:53pm
Subject:Re: Exporting the result of a Query into excel
View as plain text  
We have to use outfile with select stmt, not with show.
Suresh Kuna
Sent from BlackBerry® on Airtel

-----Original Message-----
From: ishaq gbola <ishaqgbo@strippedk>
Date: Tue, 5 Jan 2010 13:45:44 
To: <mysql@strippedql.com>
Subject: Re: Exporting the result of a Query into excel

As test i tried this and I got the result below

mysql> show tables into outfile "trial.txt"
    -> ;
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresp  onds to your MySQL server version for the right syntax to use near 'into outfile                                    
"trial.txt"' at line 1
mysql>


--- On Tue, 5/1/10, Jay Ess <lists@strippedom> wrote:

From: Jay Ess <lists@stripped>
Subject: Re: Exporting the result of a Query into excel
To: 
Cc: mysql@stripped
Date: Tuesday, 5 January, 2010, 13:35

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 multitude of choice how to transfer the file. scp,ftp,http,mail all depending on what's installed on the server and what access you got to it.



-- MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=ishaqgbo@stripped





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