Carsten:
Can you demonstrate this?
~Lawrence
Carsten Pedersen wrote:
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