npm

perl-dbd-mysql

MySQL driver for Perl5 Database Interface (DBI)

brewmacoslinux

Try with needOr install directly

Source

About

MySQL driver for the Perl5 Database Interface (DBI)

Commands

perl-dbd-mysql

Examples

Connect to MySQL database and execute a query in Perl

$ perl -e 'use DBI; my $dbh = DBI->connect("dbi:mysql:database=mydb:host=localhost", "user", "pass"); my $sth = $dbh->prepare("SELECT * FROM users"); $sth->execute(); while(my @row = $sth->fetchrow_array) { print "@row\n"; }'

Insert data into MySQL database using prepared statements

$ perl -e 'use DBI; my $dbh = DBI->connect("dbi:mysql:database=mydb", "user", "pass"); my $sth = $dbh->prepare("INSERT INTO users (name, email) VALUES (?, ?)"); $sth->execute("John", "john@example.com"); print "Inserted\n";'

Check database connection and list tables

$ perl -e 'use DBI; my $dbh = DBI->connect("dbi:mysql:database=mydb", "user", "pass") or die $DBI::errstr; print "Connected\n"; my @tables = $dbh->tables(); print "@tables\n";'