You're off to a good start. Make sure you install the DBD::mysql package, then you should be able to start using it. The DBI module is very popular, so you can easily find plenty of examples to help you out. Going off the top of my head, you'll be doing something a bit like:

use strict;
use warnings;
use DBI;

my $DB = DBI::connect("connect string for your database", "user ID", "
+password");

# Prepare a statement handle for your inserts
my $STH = $DB->prepare("insert into mytable (col1, col2) values (?, ?)
+");

while (<DATA>) {
    # Get  your data
    my ($col1, $col2) = parse_line($_);
    # Now insert it into the database
    $STH->execute($col1, $col2);
}

[download]

This example uses a prepared statement with placeholders (the ? marks) because:

Placeholders are just the ? marks, which have a one-to-one correspondence with the values you give the $STH->execute() function. Note that you can't use placeholders for table names or column names, just the values.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

Update: spelling correction.

In reply to Re: store the output of the request to the db - instead of printing by roboticus
in thread store the output of the request to the db - instead of printing by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.