List:General Discussion« Previous MessageNext Message »
From:ishaq gbola Date:January 5 2010 1:45pm
Subject:Re: Exporting the result of a Query into excel
View as plain text  
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@stripped> 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=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