I recently got help on this site on how to create a data structure given a certain data input. 
# Code that builds the structure
while ( my $line = <DATA> ) {
    chomp $line;
    
    if ( $line =~ m/^BS:\s+(\S+)/ ) {
        $result{$1} = { %queue };
        %queue = ();
    }
    else {
        my ( $name, $in_percent, $in_num, $out_percent, $out_num ) 
          = split m{ \(| / | of 1024 \| event | of 1024\)}, $line;

        $queue{$name} = {
            in_q_per  => $in_percent,
            in_q_num  => $in_num,
            out_q_per => $out_percent,
            out_q_num => $out_num,
        };
    }
}

[download]
Resulting Data structure output 
# Resulting Data structure output
'111_DDD,' => {
                'AAA_AA2_DDD' => {
                       'in_q_per' => '0%',
                       'in_q_num' => '0%',
                       'out_q_per' => '0',
                       'out_q_num' => '0'
              },
                'AAA_AA1_DDD' => {
                       'in_q_per' => '0%',
                       'in_q_num' => '0%',
                       'out_q_per' => '0',
                       'out_q_num' => '0'
              },

              ...etc...

[download]
The code worked perfectly and when you print Data::Dumper it prints it out like it shows above. I have been trying to get this data structure into a mysql database for days with out much luck Can you give me some examples of how I can get it into a table like the one below. Ive already tried a foreach within a foreach but each time the I get stuff like this HASH(0x9c9d628) inserted. 
#MYSQL TABLE
BS       queue_name   in_q_per in_q_num  out_q_per out_q_num
------------------------------------------------------------
111_DDD  AAA_AA1_DDD    0%        0          0%         0
111_DDD  AAA_AA2_DDD    0%        0          0%         0
222_DDD  BBB_BB1_DDD    0%        0          0%         0
222_DDD  BBB_BB1_DDD    0%        0          0%         0
333_DDD  CCC_CC1_DDD    0%        0          0%         0
333_DDD  CCC_CC1_DDD    0%        0          0%         0

[download]
__DATA INPUT__
AAA_AA1_DDD (0% / 0 of 1024 | event 0% / 0 of 1024)
AAA_AA2_DDD (0% / 0 of 1024 | event 0% / 0 of 1024)
BS: 111_DDD, QE: QQQ_DDD (additionnal QE)
BBB_BB1_DDD (0% / 0 of 1024 | event 0% / 0 of 1024)
BBB_BB2_DDD (0% / 0 of 1024 | event 0% / 0 of 1024)
BS: 222_DDD, QE: QQQ_DDD (additionnal QE)
CCC_CC1_DDD (0% / 0 of 1024 | event 0% / 0 of 1024)
CCC_CC2_DDD (0% / 0 of 1024 | event 0% / 0 of 1024)
BS: 333_DDD, QE: QQQ_DDD (additionnal QE)

[download]

In reply to Hash of Hash to mysql by NothingInCommon

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.