Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^2: Monitoring mysql tables in perl

by kamal (Sexton)
on Jan 10, 2013 at 15:43 UTC ( #1012688=note: print w/ replies, xml ) Need Help??


in reply to Re: Monitoring mysql tables in perl
in thread Monitoring mysql tables in perl

no those are made up usernames and passwords, and this is not for production. as far as what i am trying to do is to get reuslts like: staus| time s 10:55 k 12:20 e 13:10 so the table contains char's which change as a result of some other process, i just want to be able to store these values in a csv format, so i can render it in a graph. Hope this makes a bit more sense


Comment on Re^2: Monitoring mysql tables in perl
Re^3: Monitoring mysql tables in perl
by blue_cowdawg (Prior) on Jan 10, 2013 at 15:54 UTC
        i just want to be able to store these values in a csv format, so i can render it in a graph.

    Rendering an array of data into a CSV row is fairly simple. Here's one example:

    #!/usr/bin/perl use strict; my $data = [ [ qw/ a b c d /], [ qw/ e f g h /], [ qw/ i j k l /] ]; my $outfile = "/path/to/my/file.csv"; open FOUT,"> $outfile" or die "$outfile: $!"; foreach my $row (@$data){ printf FOUT "%s\n',join(",",@$row); } close FOUT;
    There are many many other ways of doing this but there is one way.


    Peter L. Berghold -- Unix Professional
    Peter -at- Berghold -dot- Net; AOL IM redcowdawg Yahoo IM: blue_cowdawg

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1012688]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (9)
As of 2014-08-20 05:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (105 votes), past polls