What you'll need to look at the DBI module and the MySql DBD Driver.

You'll also need to look at open to open your text file and read it in.

I'll leave the rest up to you and if you need any more help please feel free to ask it here with some code samples to help us out

If you are interested you can look at some nodes pertaining to asking questions (so you can make sure you get the best answer possible):
  • turnstep's Home Node
  • On Asking for help
  • Before you post...
  • How to ReadTheFineManual


    • grep
    grep> cd /pub
    grep> more beer

    In reply to Re: extracting data out of a txt file by grep
    in thread extracting data out of a txt file by luditus

    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.