Newbie with a problem

[padawanlinuxero]

Hello all!!!


I am learning Perl here at my work, but right now I have a problem, I was reading about DBI, which is very cool since we use a lot of old DBF tables, so I am able to get the DBF data to CSV, but I was wondering is there a way to put it in MySql tables

I have here a small example to turn DBF to CSV but how to make it to MySql table? can you help me?

#!/usr/bin/perl
use warnings;
use strict;
use DBI;
 
my $dbhX = DBI->connect('dbi:XBase(RaiseError=1):');
my $dbhC = DBI->connect('dbi:CSV(RaiseError=1):');
my $select = $dbhX->prepare("SELECT * FROM reg501");
$select->execute();
 
if (-e "c:/proyecto/xtestcsv.csv")
{
    print "Advertencia el archivo existe iniciando el borrando del mismo ";
         unlink ('c:/proyecto/xtestcsv.csv');
}
 
$dbhC->do("CREATE TABLE xtestcsv.csv AS IMPORT(?)",{},$select);

[numberwhun]

Well, first, you would have to use the mysql DBD. Second, you will need to check the mySql manual and see if itmports the import function you are using. If so, you are in good shape.

Regards,

Jeff

[eWish]

I know that you can use the LOAD DATA directly with MySQL to import a CSV file. I don't believe that the DBI supports this method.