rjsaulakh has asked for the wisdom of the Perl Monks concerning the following question:

This node falls below the community's minimum standard of quality and will not be displayed.

Replies are listed 'Best First'.
Re: perl + mysql
by xorl (Deacon) on May 26, 2005 at 12:24 UTC
Re: perl + mysql
by marto (Cardinal) on May 26, 2005 at 12:27 UTC
    Hi,

    Check out this link.
    Hope this helps.

    Cheers
    Martin
Re: perl + mysql
by lamp (Chaplain) on May 26, 2005 at 12:30 UTC
Re: perl + mysql
by tbone1 (Monsignor) on May 26, 2005 at 13:56 UTC
    how can i interact using perl with mysql

    "Poorly" would be my guess, based on empirical evidence and a cantankerous morning.

    --
    tbone1, YAPS (Yet Another Perl Schlub)
    And remember, if he succeeds, so what.
    - Chick McGee

Re: perl + mysql
by displeaser (Hermit) on May 26, 2005 at 13:17 UTC
    Hi,

    I've used Net::MySql and find it quite good for the simple tasks I gave it.

    Hope this helps
    Displeaser
Re: perl + mysql
by chas (Priest) on May 26, 2005 at 14:35 UTC
    Here is a simple script to test use of DBI, etc:
    use DBI; @driver_names = DBI->available_drivers; print "@driver_names\n"; $DSN="DBI:mysql:database=test"; my $dbi=DBI->connect($DSN,"","") or die "Can't connect\n"; my $sth=$dbi->prepare("SHOW DATABASES"); $sth->execute(); $databases=$sth->fetchall_arrayref; for(@$databases){print "@$_\n"} $sth->finish(); $dbi->disconnect; exit;

    (You have to have mysql running first. Also, in the connect statement you may need to put the username and password; you can give the password as an argument to the script so you don't hardcode it in.)
    chas