From: Jim Lyons (jlyons4435gmail.com)
Date: Tue Jan 05 2010 - 10:27:45 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <ishaqgboyahoo.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 <listsnetrogenic.com> wrote:
>
> From: Jay Ess <listsnetrogenic.com>
> Subject: Re: Exporting the result of a Query into excel
> To: "mysqllists.mysql.com >> Mysql" <mysqllists.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=ishaqgboyahoo.co.uk
>
>
>
>
>

--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]