perl-MySQL-Easy - Perl extension to handle various mundane DBI session related things specific to mysql

Property Value
Distribution ALT Linux Sisyphus
Repository Autoimports noarch
Package name perl-MySQL-Easy
Package version 2.1019
Package release alt2
Package architecture noarch
Package type rpm
Installed size 24.26 KB
Download size 24.26 KB
Official Mirror
I don't remember how I used to live without this...  I do like the way the DBI manpage
and the DBD::mysql manpage work, but I wanted something *slightly* prettier...
*slightly* handier.
Here are the functions the MySQL::Easy manpage provides:
=item new
$dbo = MySQL::Easy->new( $db_name, $trace )
`$db_name' is the name of the database you're connecting to...  If you don't
pick anything, it'll pick "test" for you.  `$trace' is a 1 or false, ... it's
the DBI->trace() ...
$dbo = MySQL::Easy->new( $db_name, {user=>"blarg", host=>"whatever"})
Alternatively, you can pass a hashref of options in place of the trace argument.
Passing `user=>"blarg"' in this way is the same as calling
`$dbo->set_user()' -- so this is really only good for avoiding calls to
`set_user', `set_pass', and `set_host'; although, `trace' also works as an
attribute here by calling the function of the same name.
=item do
$dbo->do("sql statement bind=? bind=?", $bind1, $bind2);
This immediately executes the SQL with the bind vars given.  You can pas in a
statement handle instead of the string... this is faster if you're going to use
the SQL over and over.  Returns a bool like you'd expect.  Example:
=item lock
$dbo->lock("table1", "table2", "table3");
the MySQL::Easy manpage uses only write locks.  Those are the ones where nobody can read
or write to the table except the locking thread.  If you need a read lock, let
me know.  Most probably though, if you're using this, it's a smaller app, and it
doesn't matter anyway.
=item ready
$sth = $dbo->ready("Sql Sql Sql=? and Sql=?");
$sth->fetchrow_hashref; # etc...
`ready()' returns a DBI statement handle,
mostly.  The the MySQL::Easy manpage statement handles automatically recover from
disconnects.  At the time of this writing, the DBI manpage statement handles do not do
this (although the database handle does).
=item firstcol
$arr = $dbo->firstcol("select col from tab w...


Package Version Architecture Repository
perl-MySQL-Easy - - -


Name Value
/usr/share/perl5 -
perl( -
perl(Scalar/ -
perl(common/ -
perl( -
rpmlib(PayloadIsLzma) -


Name Value
perl(MySQL/ = 2.101.900
perl-MySQL-Easy = 2.1019-alt2


Type URL
Binary Package perl-MySQL-Easy-2.1019-alt2.noarch.rpm
Source Package perl-MySQL-Easy-2.1019-alt2.src.rpm

Install Howto

  1. Add the following line to /etc/apt/sources.list:
    rpm [Sisyphus] noarch autoimports
    rpm [Sisyphus] noarch autoimports
  2. Update the package index:
    # sudo apt-get update
  3. Install perl-MySQL-Easy rpm package:
    # sudo apt-get install perl-MySQL-Easy



See Also

Package Description
perl-MySQL-Explain-Parser-0.02-alt1.noarch.rpm Parser for result of EXPLAIN of MySQL
perl-MySQL-GrantParser-1.003-alt1.noarch.rpm parse SHOW GRANTS and return as hash reference
perl-MySQL-Handler-2.1-alt1.noarch.rpm Builds upon DBD::mysql for advanced CGI web apps
perl-MySQL-Insert-0.06-alt1.noarch.rpm extended inserts for MySQL via DBI
perl-MySQL-Log-ParseFilter-1.00-alt1.noarch.rpm perl module MySQL-Log-ParseFilter
perl-MySQL-Packet-0.2007054-alt1.noarch.rpm encode and decode the MySQL binary protocol
perl-MySQL-Partition-1.0001-alt1.noarch.rpm Utility for MySQL partitioning
perl-MySQL-Privilege-Reader-0.01-alt1.noarch.rpm Determines which privileges are valid for a given MySQL Database Connection
perl-MySQL-QueryMulti-0.08-alt1.noarch.rpm module for querying multiple MySQL databases in parallel
perl-MySQL-QueryMulti-scripts-0.08-alt1.noarch.rpm MySQL-QueryMulti scripts
perl-MySQL-Replication-0.0.2-alt1.noarch.rpm Decentralised, peer-to-peer, multi-master MySQL replication
perl-MySQL-Replication-scripts-0.0.2-alt1.noarch.rpm MySQL-Replication scripts
perl-MySQL-RunSQL-1.2-alt1.noarch.rpm Run SQL queries against a MySQL database and return the
perl-MySQL-Sandbox-3.2.18-alt1.noarch.rpm Quickly installs MySQL side server, either standalone or in groups
perl-MySQL-Sandbox-scripts-3.2.18-alt1.noarch.rpm MySQL-Sandbox scripts