<mode="inquisitive>

Your question is unclear. (How (Not) To Ask A Question, Before asking a database related question ...)

Why are you talking about a statement handler?

What did you try?

If you tried anything, did you get any errors?

Have you read the DBI docs?

What is it you don't understand?

</mode>

<mode="helpful>

Perhaps you nees something along the lines of:

my $dbh=DBI->connect("dbi:mysql:databasename",
    "username", "password", {RaiseError=>1}) 
    or die "DOES NOT CONNECT";

my $rows_affected = $dbh->do(
    "LOAD DATA LOCAL INFILE 'file' INTO TABLE table_name");
[download]

</mode>