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
