Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Link table to external CSV

1 view
Skip to first unread message

rjre

unread,
Nov 19, 2009, 4:44:07 AM11/19/09
to
Morning all,

Is it possible to create a table in Mysql that "links" to an external
CSV
file?

I have found a couple of mentions to a CSV Engine - but cannot find
any
basic "newbie" information.

thank you

richard

Johannes Keßler

unread,
Nov 19, 2009, 4:59:21 AM11/19/09
to
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Why would you want this ?

You can import without any complicated way a CSV file into MySQL table and the
use this table.
Then you can create a cron job which checks if the file is modified and then
re-load it into the table again.

regards,
johannes keßler
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.13 (GNU/Linux)

iEYEARECAAYFAksFFvgACgkQE++2Zdc7EtdgogCaAymzToPUquEV+TSg/Wq+lWgA
EVIAniIjxTZG1SKuon/DekY7d1sqQg6E
=HsA5
-----END PGP SIGNATURE-----

Axel Schwenke

unread,
Nov 19, 2009, 5:41:53 AM11/19/09
to
rjre <rjred...@googlemail.com> wrote:
>
> I have found a couple of mentions to a CSV Engine - but cannot find
> any basic "newbie" information.

"www.mysql.com"
"Documentation" in top menu
"MySQL 5.1 Reference Manual" in left menu
"13 Storage Engines" in section navigation
"13.13 The CSV Storage Engine"

Is that really hard to find?

Also: typing "mysql csv engine" into Google, the first
result links here:

http://dev.mysql.com/tech-resources/articles/csv-storage-engine.html


XL

Johannes Keßler

unread,
Nov 19, 2009, 6:16:10 AM11/19/09
to
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Whoa didn't know that this is "real".

But right now I can't think of any idea why this would be usefull..

regards,
johannes Keßler


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.13 (GNU/Linux)

iEYEARECAAYFAksFKPoACgkQE++2Zdc7EtcihACfVvh/Q7bS/9Y05CcCTYjHA8fa
/bAAnjg4EbPDUhSXbRHR2jcciTTfnGcG
=pzky
-----END PGP SIGNATURE-----

Peter H. Coffin

unread,
Nov 19, 2009, 11:13:57 AM11/19/09
to
On Thu, 19 Nov 2009 12:16:10 +0100, Johannes Ke�ler wrote:
>
> Axel Schwenke wrote:
>> rjre <rjred...@googlemail.com> wrote:
>>> I have found a couple of mentions to a CSV Engine - but cannot find
>>> any basic "newbie" information.
>>
>> "www.mysql.com"
>> "Documentation" in top menu
>> "MySQL 5.1 Reference Manual" in left menu
>> "13 Storage Engines" in section navigation
>> "13.13 The CSV Storage Engine"
>>
>> Is that really hard to find?
>>
>> Also: typing "mysql csv engine" into Google, the first
>> result links here:
>>
>> http://dev.mysql.com/tech-resources/articles/csv-storage-engine.html
>>
>>
>> XL
>
>
> Whoa didn't know that this is "real".
>
> But right now I can't think of any idea why this would be usefull..

Huge tables of rarely-used archival data come to mind.

--
67. No matter how many shorts we have in the system, my guards will be
instructed to treat every surveillance camera malfunction as a
full-scale emergency.
--Peter Anspach's list of things to do as an Evil Overlord

0 new messages