Home > Archive > PERL Beginners > September 2007 > import CSV files in MYSQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
import CSV files in MYSQL
|
|
|
| Hello people..
I have one file with data in CSV where first line is header..
Don't have one module for this?
Thanks :D
| |
|
| if you have access to the mysql client and server you don't need any
modules, just use the "load data" sql command with all the requisite
parameters.
if you need to make a perl script for it, just use the standard dbd
(or dbi, i forget currently which is parent to which) module to
connect, then use "load data" anyway as the sql command.
the specific parameters will depend on where the file is located, how
the fields are enclosed, terminated, etc....
On 8/31/07, Ana <ana.travezani@gmail.com> wrote:
> Hello people..
> I have one file with data in CSV where first line is header..
> Don't have one module for this?
>
>
> Thanks :D
>
>
> --
> To unsubscribe, e-mail: beginners-unsubscribe@perl.org
> For additional commands, e-mail: beginners-help@perl.org
> http://learn.perl.org/
>
>
>
--
since this is a gmail account, please verify the mailing list is
included in the reply to addresses
| |
|
| On 31 ago, 22:35, jm5...@gmail.com (Jm) wrote:
> if you have access to the mysql client and server you don't need any
> modules, just use the "load data" sql command with all the requisite
> parameters.
>
> if you need to make a perl script for it, just use the standard dbd
> (or dbi, i forget currently which is parent to which) module to
> connect, then use "load data" anyway as the sql command.
>
> the specific parameters will depend on where the file is located, how
> the fields are enclosed, terminated, etc....
>
> On 8/31/07, Ana <ana.travez...@gmail.com> wrote:
>
>
>
>
> --
> since this is a gmail account, please verify the mailing list is
> included in the reply to addresses
Hello.. I need process any calculate before insert Mysql..
I try use Text:CSV.. :D but don't could use..
Thanks :D
| |
|
| On Sep 3, 9:13 am, ana.travez...@gmail.com (Ana) wrote:
> On 31 ago, 22:35, jm5...@gmail.com (Jm) wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hello.. I need process any calculate before insert Mysql..
> I try use Text:CSV.. :D but don't could use..
>
> Thanks :D- Hide quoted text -
>
> - Show quoted text -
Hello People :D
How I acess value using Text:CSV ?????
Thanks
|
|
|
|
|