--0-1891122999-1262697477=:95654
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
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
=0A
--0-1891122999-1262697477=:95654--
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=gcdmg-mysql-2@m.gmane.org
--0016e6d64b18e1267c047c6acdae
Content-Type: text/plain; charset=ISO-8859-1
You can use the --xml option to the mysql command to get xnl output. You
can also get a tab-delimited output file that can be read into Excel (this
is what I usually do).
To get a tab-delimited file, you can use the --tab option of mysqldump or
start up the mysql program with the -sss option and do a select on the data
you want, redirecting it into an output file.
On Tue, Jan 5, 2010 at 7:17 AM, ishaq gbola
> 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
>
>
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
--0016e6d64b18e1267c047c6acdae--
--0-1009217372-1262698319=:21742
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
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
From: Jay Ess
Subject: Re: Exporting the result of a Query into excel
To: "mysql@lists.mysql.com >> Mysql"
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 o=
ne to export the result of query into excel formart
> =A0
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
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:=A0 =A0 http://lists.mysql.com/mysql?unsub=3Dishaqgbo@yahoo.=
co.uk
=0A
--0-1009217372-1262698319=:21742--
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=gcdmg-mysql-2@m.gmane.org
SGkNCldoYXQgaXMgdGhlIE9TIHlvdSBhcmUgdXNpbmcgb24gdGhlIHJlbW90 ZSBhbmQgbG9jYWwg
c2VydmVyLg0KSXMgdGhlcmUgYSBteXNxbCBjbGllbnQgb24gbG9jYWwgc2Vy dmVyPw0KDQpUaGFu
a3MNClN1cmVzaCBLdW5hDQpTZW50IGZyb20gQmxhY2tCZXJyea4gb24gQWly dGVsDQoNCi0tLS0t
T3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBpc2hhcSBnYm9sYSA8aXNo YXFnYm9AeWFob28u
Y28udWs+DQpEYXRlOiBUdWUsIDUgSmFuIDIwMTAgMTM6MzE6NTkgDQpUbzog PG15c3FsQGxpc3Rz
Lm15c3FsLmNvbT4NClN1YmplY3Q6IFJlOiBFeHBvcnRpbmcgdGhlIHJlc3Vs dCBvZiBhIFF1ZXJ5
IGludG8gZXhjZWwNCg0KVGhhbmtzIGEgbG90IGZvciB0aGF0LCBidXQgd2hl cmUgZG9lcyB0aGlz
IGZpbGUgZ2V0IHNhdmVkIGluIGFuZCBob3cgY2FuIGkgY29weSBpdCB0byBt eSBsb2NhbCBob3N0
IGlmIHRoZSBkYXRhYmFzZSBpcyBvbiBhIHJlbW90ZSBzZXJ2ZXINCg0KLS0t IE9uIFR1ZSwgNS8x
LzEwLCBKYXkgRXNzIDxsaXN0c0BuZXRyb2dlbmljLmNvbT4gd3JvdGU6DQoN CkZyb206IEpheSBF
c3MgPGxpc3RzQG5ldHJvZ2VuaWMuY29tPg0KU3ViamVjdDogUmU6IEV4cG9y dGluZyB0aGUgcmVz
dWx0IG9mIGEgUXVlcnkgaW50byBleGNlbA0KVG86ICJteXNxbEBsaXN0cy5t eXNxbC5jb20gPj4g
TXlzcWwiIDxteXNxbEBsaXN0cy5teXNxbC5jb20+DQpEYXRlOiBUdWVzZGF5 LCA1IEphbnVhcnks
IDIwMTAsIDEzOjIyDQoNCmlzaGFxIGdib2xhIHdyb3RlOg0KPiBIaSBhbGws DQo+DQo+IEkgd291
bGQgbGlrZSB0byBrbm93IGlmIHRoZXJlIGlzIGEgdG9vbCBvciBjb21tYW5k IGluIG15U1FMIHRo
YXQgYWxsb3dzIG9uZSB0byBleHBvcnQgdGhlIHJlc3VsdCBvZiBxdWVyeSBp bnRvIGV4Y2VsIGZv
cm1hcnQNCj6goKANCnNlbGVjdCAqIGZyb20gdGFibGUgaW50byBvdXRmaWxl ICJ0aGVmaWxlLnR4
dCI7DQpUaGF0IGNhbiBiZSBpbXBvcnRlZCBpbnRvIGV4Y2VsIHVzaW5nIENT ViBhbmQgdXNpbmcg
IlRBQiIgYXMgc2VwYXJhdG9yLg0KaHR0cDovL2NvZGUuYW5qYW5lc2gubmV0 LzIwMDcvMTIvZXhw
b3J0LW15c3FsLWRhdGEtdG8tZXhjZWwtY29tcGF0aWJsZS5odG1sDQoNCi0t IA0KTXlTUUwgR2Vu
ZXJhbCBNYWlsaW5nIExpc3QNCkZvciBsaXN0IGFyY2hpdmVzOiBodHRwOi8v bGlzdHMubXlzcWwu
Y29tL215c3FsDQpUbyB1bnN1YnNjcmliZTqgIKAgaHR0cDovL2xpc3RzLm15 c3FsLmNvbS9teXNx
bD91bnN1Yj1pc2hhcWdib0B5YWhvby5jby51aw0KDQoKCgoNCg==
--0-892719561-1262698940=:8963
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Am running windows on my local host and Redhat linux on the remote server, =
I have no mysql client on local host. TAC for the NMS using the database ad=
viced me not to use a msqlclient for it, that it could break the database??=
?=20
--- On Tue, 5/1/10, sureshkumarilu@gmail.com
te:
From: sureshkumarilu@gmail.com
Subject: Re: Exporting the result of a Query into excel
To: "ishaq gbola"
Date: Tuesday, 5 January, 2010, 13:37
Hi
What is the OS you are using on the remote and local server.
Is there a mysql client on local server?
Thanks
Suresh Kuna
Sent from BlackBerry=AE on Airtel
-----Original Message-----
From: ishaq gbola
Date: Tue, 5 Jan 2010 13:31:59=20
To:
Subject: Re: Exporting the result of a Query into excel
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
From: Jay Ess
Subject: Re: Exporting the result of a Query into excel
To: "mysql@lists.mysql.com >> Mysql"
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 o=
ne to export the result of query into excel formart
> =A0
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=
=0A
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql=0A
To unsubscribe:=A0 =A0 http://lists.mysql.com/mysql?unsub=3Dishaqgbo@yahoo.=
co.uk=0A
=0A
--0-892719561-1262698940=:8963--
--0-478969647-1262699144=:10702
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
As test i tried this and I got the result below
mysql> show tables into outfile "trial.txt"
=A0 -> ;
ERROR 1064: You have an error in your SQL syntax.=A0 Check the manual that =
corresp=A0 onds to your MySQL server version for the right syntax to use ne=
ar 'into outfile =A0=A 0=A0=
=A0 "trial.txt"' at line 1
mysql>
--- On Tue, 5/1/10, Jay Ess
From: Jay Ess
Subject: Re: Exporting the result of a Query into excel
To:=20
Cc: mysql@lists.mysql.com
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
> =A0
If you don't specify the absolute location it can be find in "DATADIR/Datab=
aseName/". And after you located the file you have a multitude of choice ho=
w 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:=A0 =A0 http://lists.mysql.com/mysql?unsub=3Dishaqgbo@yahoo.=
co.uk
=0A
--0-478969647-1262699144=:10702--
T2suIEluIHdpbmRvd3MsIFVzZSB3aW5zY3AgdG9vbCwgY29ubmVjdCB0byB0 aGUgc2VydmVyIGFu
ZCBjb3B5IHRoZSBmaWxlIHRvIGxvY2FsIG1hY2hpbmUgYW5kIGltcG9ydCBp dCBpbiBleGNlbC4N
ClRoYW5rcw0KU3VyZXNoIEt1bmENClNlbnQgZnJvbSBCbGFja0JlcnJ5riBv biBBaXJ0ZWwNCg0K
LS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IGlzaGFxIGdib2xh IDxpc2hhcWdib0B5
YWhvby5jby51az4NCkRhdGU6IFR1ZSwgNSBKYW4gMjAxMCAxMzo0MjoyMCAN ClRvOiA8bXlzcWxA
bGlzdHMubXlzcWwuY29tPg0KU3ViamVjdDogUmU6IEV4cG9ydGluZyB0aGUg cmVzdWx0IG9mIGEg
UXVlcnkgaW50byBleGNlbA0KDQpBbSBydW5uaW5nIHdpbmRvd3Mgb24gbXkg bG9jYWwgaG9zdCBh
bmQgUmVkaGF0IGxpbnV4IG9uIHRoZSByZW1vdGUgc2VydmVyLCBJIGhhdmUg bm8gbXlzcWwgY2xp
ZW50IG9uIGxvY2FsIGhvc3QuIFRBQyBmb3IgdGhlIE5NUyB1c2luZyB0aGUg ZGF0YWJhc2UgYWR2
aWNlZCBtZSBub3QgdG8gdXNlIGEgbXNxbGNsaWVudCBmb3IgaXQsIHRoYXQg aXQgY291bGQgYnJl
YWsgdGhlIGRhdGFiYXNlPz8/IA0KDQotLS0gT24gVHVlLCA1LzEvMTAsIHN1 cmVzaGt1bWFyaWx1
QGdtYWlsLmNvbSA8c3VyZXNoa3VtYXJpbHVAZ21haWwuY29tPiB3cm90ZToN Cg0KRnJvbTogc3Vy
ZXNoa3VtYXJpbHVAZ21haWwuY29tIDxzdXJlc2hrdW1hcmlsdUBnbWFpbC5j b20+DQpTdWJqZWN0
OiBSZTogRXhwb3J0aW5nIHRoZSByZXN1bHQgb2YgYSBRdWVyeSBpbnRvIGV4 Y2VsDQpUbzogImlz
aGFxIGdib2xhIiA8aXNoYXFnYm9AeWFob28uY28udWs+LCBteXNxbEBsaXN0 cy5teXNxbC5jb20N
CkRhdGU6IFR1ZXNkYXksIDUgSmFudWFyeSwgMjAxMCwgMTM6MzcNCg0KSGkN CldoYXQgaXMgdGhl
IE9TIHlvdSBhcmUgdXNpbmcgb24gdGhlIHJlbW90ZSBhbmQgbG9jYWwgc2Vy dmVyLg0KSXMgdGhl
cmUgYSBteXNxbCBjbGllbnQgb24gbG9jYWwgc2VydmVyPw0KDQpUaGFua3MN ClN1cmVzaCBLdW5h
DQpTZW50IGZyb20gQmxhY2tCZXJyea4gb24gQWlydGVsDQoNCi0tLS0tT3Jp Z2luYWwgTWVzc2Fn
ZS0tLS0tDQpGcm9tOiBpc2hhcSBnYm9sYSA8aXNoYXFnYm9AeWFob28uY28u dWs+DQpEYXRlOiBU
dWUsIDUgSmFuIDIwMTAgMTM6MzE6NTkgDQpUbzogPG15c3FsQGxpc3RzLm15 c3FsLmNvbT4NClN1
YmplY3Q6IFJlOiBFeHBvcnRpbmcgdGhlIHJlc3VsdCBvZiBhIFF1ZXJ5IGlu dG8gZXhjZWwNCg0K
VGhhbmtzIGEgbG90IGZvciB0aGF0LCBidXQgd2hlcmUgZG9lcyB0aGlzIGZp bGUgZ2V0IHNhdmVk
IGluIGFuZCBob3cgY2FuIGkgY29weSBpdCB0byBteSBsb2NhbCBob3N0IGlm IHRoZSBkYXRhYmFz
ZSBpcyBvbiBhIHJlbW90ZSBzZXJ2ZXINCg0KLS0tIE9uIFR1ZSwgNS8xLzEw LCBKYXkgRXNzIDxs
aXN0c0BuZXRyb2dlbmljLmNvbT4gd3JvdGU6DQoNCkZyb206IEpheSBFc3Mg PGxpc3RzQG5ldHJv
Z2VuaWMuY29tPg0KU3ViamVjdDogUmU6IEV4cG9ydGluZyB0aGUgcmVzdWx0 IG9mIGEgUXVlcnkg
aW50byBleGNlbA0KVG86ICJteXNxbEBsaXN0cy5teXNxbC5jb20gPj4gTXlz cWwiIDxteXNxbEBs
aXN0cy5teXNxbC5jb20+DQpEYXRlOiBUdWVzZGF5LCA1IEphbnVhcnksIDIw MTAsIDEzOjIyDQoN
CmlzaGFxIGdib2xhIHdyb3RlOg0KPiBIaSBhbGwsDQo+DQo+IEkgd291bGQg bGlrZSB0byBrbm93
IGlmIHRoZXJlIGlzIGEgdG9vbCBvciBjb21tYW5kIGluIG15U1FMIHRoYXQg YWxsb3dzIG9uZSB0
byBleHBvcnQgdGhlIHJlc3VsdCBvZiBxdWVyeSBpbnRvIGV4Y2VsIGZvcm1h cnQNCj6goKANCnNl
bGVjdCAqIGZyb20gdGFibGUgaW50byBvdXRmaWxlICJ0aGVmaWxlLnR4dCI7 DQpUaGF0IGNhbiBi
ZSBpbXBvcnRlZCBpbnRvIGV4Y2VsIHVzaW5nIENTViBhbmQgdXNpbmcgIlRB QiIgYXMgc2VwYXJh
dG9yLg0KaHR0cDovL2NvZGUuYW5qYW5lc2gubmV0LzIwMDcvMTIvZXhwb3J0 LW15c3FsLWRhdGEt
dG8tZXhjZWwtY29tcGF0aWJsZS5odG1sCg0KDQotLSANCk15U1FMIEdlbmVy YWwgTWFpbGluZyBM
aXN0DQpGb3IgbGlzdCBhcmNoaXZlczogaHR0cDovL2xpc3RzLm15c3FsLmNv bS9teXNxbAoNClRv
IHVuc3Vic2NyaWJlOqAgoCBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3Fs P3Vuc3ViPWlzaGFx
Z2JvQHlhaG9vLmNvLnVrCg0KDQoNCg0KDQoNCgoKCg0K
V2UgaGF2ZSB0byB1c2Ugb3V0ZmlsZSB3aXRoIHNlbGVjdCBzdG10LCBub3Qg d2l0aCBzaG93Lg0K
U3VyZXNoIEt1bmENClNlbnQgZnJvbSBCbGFja0JlcnJ5riBvbiBBaXJ0ZWwN Cg0KLS0tLS1Pcmln
aW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IGlzaGFxIGdib2xhIDxpc2hhcWdi b0B5YWhvby5jby51
az4NCkRhdGU6IFR1ZSwgNSBKYW4gMjAxMCAxMzo0NTo0NCANClRvOiA8bXlz cWxAbGlzdHMubXlz
cWwuY29tPg0KU3ViamVjdDogUmU6IEV4cG9ydGluZyB0aGUgcmVzdWx0IG9m IGEgUXVlcnkgaW50
byBleGNlbA0KDQpBcyB0ZXN0IGkgdHJpZWQgdGhpcyBhbmQgSSBnb3QgdGhl IHJlc3VsdCBiZWxv
dw0KDQpteXNxbD4gc2hvdyB0YWJsZXMgaW50byBvdXRmaWxlICJ0cmlhbC50 eHQiDQqgoKAgLT4g
Ow0KRVJST1IgMTA2NDogWW91IGhhdmUgYW4gZXJyb3IgaW4geW91ciBTUUwg c3ludGF4LqAgQ2hl
Y2sgdGhlIG1hbnVhbCB0aGF0IGNvcnJlc3CgIG9uZHMgdG8geW91ciBNeVNR TCBzZXJ2ZXIgdmVy
c2lvbiBmb3IgdGhlIHJpZ2h0IHN5bnRheCB0byB1c2UgbmVhciAnaW50byBv dXRmaWxloKCgoKCg
oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgICJ0cmlhbC50eHQiJyBh dCBsaW5lIDENCm15
c3FsPg0KDQoNCi0tLSBPbiBUdWUsIDUvMS8xMCwgSmF5IEVzcyA8bGlzdHNA bmV0cm9nZW5pYy5j
b20+IHdyb3RlOg0KDQpGcm9tOiBKYXkgRXNzIDxsaXN0c0BuZXRyb2dlbmlj LmNvbT4NClN1Ympl
Y3Q6IFJlOiBFeHBvcnRpbmcgdGhlIHJlc3VsdCBvZiBhIFF1ZXJ5IGludG8g ZXhjZWwNClRvOiAN
CkNjOiBteXNxbEBsaXN0cy5teXNxbC5jb20NCkRhdGU6IFR1ZXNkYXksIDUg SmFudWFyeSwgMjAx
MCwgMTM6MzUNCg0KaXNoYXEgZ2JvbGEgd3JvdGU6DQo+IFRoYW5rcyBhIGxv dCBmb3IgdGhhdCwg
YnV0IHdoZXJlIGRvZXMgdGhpcyBmaWxlIGdldCBzYXZlZCBpbiBhbmQgaG93 IGNhbiBpIGNvcHkg
aXQgdG8gbXkgbG9jYWwgaG9zdCBpZiB0aGUgZGF0YWJhc2UgaXMgb24gYSBy ZW1vdGUgc2VydmVy
DQo+oKCgDQpJZiB5b3UgZG9uJ3Qgc3BlY2lmeSB0aGUgYWJzb2x1dGUgbG9j YXRpb24gaXQgY2Fu
IGJlIGZpbmQgaW4gIkRBVEFESVIvRGF0YWJhc2VOYW1lLyIuIEFuZCBhZnRl ciB5b3UgbG9jYXRl
ZCB0aGUgZmlsZSB5b3UgaGF2ZSBhIG11bHRpdHVkZSBvZiBjaG9pY2UgaG93 IHRvIHRyYW5zZmVy
IHRoZSBmaWxlLiBzY3AsZnRwLGh0dHAsbWFpbCBhbGwgZGVwZW5kaW5nIG9u IHdoYXQncyBpbnN0
YWxsZWQgb24gdGhlIHNlcnZlciBhbmQgd2hhdCBhY2Nlc3MgeW91IGdvdCB0 byBpdC4NCg0KDQoN
Ci0tIE15U1FMIEdlbmVyYWwgTWFpbGluZyBMaXN0DQpGb3IgbGlzdCBhcmNo aXZlczogaHR0cDov
L2xpc3RzLm15c3FsLmNvbS9teXNxbA0KVG8gdW5zdWJzY3JpYmU6oCCgIGh0 dHA6Ly9saXN0cy5t
eXNxbC5jb20vbXlzcWw/dW5zdWI9aXNoYXFnYm9AeWFob28uY28udWsNCg0K CgoKDQo=
--0016e6da7ae36970c8047c6d5196
Content-Type: text/plain; charset=ISO-8859-1
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
> 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
>
> From: Jay Ess
> Subject: Re: Exporting the result of a Query into excel
> To: "mysql@lists.mysql.com >> Mysql"
> 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=ishaqgbo@yahoo.co.uk
>
>
>
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
--0016e6da7ae36970c8047c6d5196--
>>TAC for the NMS using the database adviced me not to use a msqlclient for=
it, that it could break the database???
You are being given a false argument. If the application which
connects to MySQL is running on that windows box then there already is
a MySQL client on that machine, albeit a specialized one. Putting a
plain old client console on that same box does not hurt anything, not
even security unless you leave a text file full of passwords laying
around. Having that console on the same host as the application is
invaluable not only for data-dumping jobs like this one, but for all
kinds of trouble shooting in general.
- michael dykman
On Tue, Jan 5, 2010 at 8:42 AM, ishaq gbola
> Am running windows on my local host and Redhat linux on the remote server=
, I have no mysql client on local host. TAC for the NMS using the database =
adviced me not to use a msqlclient for it, that it could break the database=
???
>
> --- On Tue, 5/1/10, sureshkumarilu@gmail.com
rote:
>
> From: sureshkumarilu@gmail.com
> Subject: Re: Exporting the result of a Query into excel
> To: "ishaq gbola"
> Date: Tuesday, 5 January, 2010, 13:37
>
> Hi
> What is the OS you are using on the remote and local server.
> Is there a mysql client on local server?
>
> Thanks
> Suresh Kuna
> Sent from BlackBerry=AE on Airtel
>
> -----Original Message-----
> From: ishaq gbola
> Date: Tue, 5 Jan 2010 13:31:59
> To:
> Subject: Re: Exporting the result of a Query into excel
>
> 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
>
> From: Jay Ess
> Subject: Re: Exporting the result of a Query into excel
> To: "mysql@lists.mysql.com >> Mysql"
> 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.ht=
ml
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
>
> To unsubscribe:=A0 =A0 http://lists.mysql.com/mysql?unsub=3Dishaqgbo@yaho=
o.co.uk
>
>
>
>
>
>
>
>
>
>
--=20
- michael dykman
- mdykman@gmail.com
May the Source be with you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
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
>
>> 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
>>
>> From: Jay Ess
>> Subject: Re: Exporting the result of a Query into excel
>> To: "mysql@lists.mysql.com >> Mysql"
>> 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=ishaqgbo@yahoo.co.uk
>>
>>
>>
>>
>>
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
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
>> 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
>>>
>>> From: Jay Ess
>>> Subject: Re: Exporting the result of a Query into excel
>>> To: "mysql@lists.mysql.com >> Mysql"
>>> 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=ishaqgbo@yahoo.co.uk
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--0016e6d6444102eeef047c70a2c8
Content-Type: text/plain; charset=ISO-8859-1
Doesn't that depend on how often you want to do it? If it's a one-time
thing or an occasional thing, it's easier to just dump the table into a
tab-delimited file. If it's something you want to do on a regular basis,
ODBC is a way you might prefer to go.
But it also would require you to have the authority on a given box to set up
an ODBC connection (which might involve downloading software). You would
also have to do it on every machine you want to load the data on. A
tab-delimited file can be transferred to any machine, even stored on a
flash-drive and walked somewhere.
On Tue, Jan 5, 2010 at 1:50 PM, Carsten Pedersen
> 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
>>
>> 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
>>>
>>> From: Jay Ess
>>> Subject: Re: Exporting the result of a Query into excel
>>> To: "mysql@lists.mysql.com >> Mysql"
>>> 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=ishaqgbo@yahoo.co.uk
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
--0016e6d6444102eeef047c70a2c8--
> -----Original Message-----
> From: ishaq gbola [mailto:ishaqgbo@yahoo.co.uk]
> Sent: Tuesday, January 05, 2010 7:18 AM
> To: mysql@lists.mysql.com
> Subject: Exporting the result of a Query into excel
>=20
> Hi all,
>=20
> 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
>=20
>=20
If'n you can download and install Toad for MySQL, then the steps might =
go like this:
1. Write the query
2. Run the query
3. Click the "Export data to an Excel file" button/icon (if you have =
Excel 2007 installed, it might throw a warning at you) 4. Note where the =
file was created to.
5. ?
6. Profit!
The only caveat to the above is to be aware of how many rows you want to =
export and the corresponding column/row limitations of whatever version =
of Excel you have installed.
As an additional caveat, you could export to html or csv formats as well =
which would allow you to work around any size limitations imposed by =
Excel.
Jason
=20
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg