Is there any particular reason not to use the MySQL ODBC driver to
import the data directly into Excel?
/ Carsten
Jim Lyons skrev:
A command to convert the table mytab in database mydb into a tab-delimited
file mytab.txt might be:
mysql -e'select * from mydb.mytab' -sss > mytab.txt
The -sss is necessary to remove all the formatting stuff that you normally
have in the output of a select statement.
An alternative, if you have a directory *** that mysql can write to ***:
mysqldump --tab="/home/mysql/temp" mydb mytab
This will create 2 files in /home/mysql/temp: mytab.txt and mytab.sql. The
one you'll want is in mytab.txt.
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 <ishaq...@yahoo.co.uk> 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 <li...@netrogenic.com> wrote:
From: Jay Ess <li...@netrogenic.com>
Subject: Re: Exporting the result of a Query into excel
To: "mysql@lists.mysql.com >> Mysql" <mysql@lists.mysql.com>
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=ishaq...@yahoo.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
