MPMinus::Store::MySQL - MySQL MPMinus::Store::DBI interface
Version 1.42
use MPMinus::Store::MySQL; # MySQL connect my $mysql = new MPMinus::Store::MySQL ( -host => '192.168.1.1', -database => 'TEST', -user => 'login', -pass => 'password', -attr => { mysql_enable_utf8 => 1, RaiseError => 0, PrintError => 0, }, ); my $dbh = $mysql->connect; my $pingstat = $mysql->ping if $mysql; # Table select (as array) my @result = $mysql->table($sql, @inargs); # Table select (as hash) my %result = $mysql->tableh($key, $sql, @inargs); # $key - primary index field name # Record (as array) my @result = $mysql->record($sql, @inargs); # Record (as hash) my %result = $mysql->recordh($sql, @inargs); # Fiels (as scalar) my $result = $mysql->field($sql, @inargs); # SQL/PL-SQL my $sth = $mysql->execute($sql, @inargs); ... $sth->finish;
MySQL MPMinus::Store::DBI interface
See MPMinus::Store::DBI
use MPMinus::Store::MySQL; my $mysql = new MPMinus::Store::MySQL ( -host => '192.168.1.1', -name => 'mylocaldb', -user => 'root', -password => 'password', ); my @table = $mysql->table("select * from tablename where date = ?", "01.01.2000")
Init version
OOP style supported
Module movied to global level
Module movied to MPMinus level
General refactoring
See CHANGES file
CHANGES
MPMinus::Store::DBI, DBD::mysql
See TODO file
TODO
* none noted
Serż Minus (Sergey Lepenkov) http://www.serzik.com <abalama@cpan.org>
Copyright (C) 1998-2019 D&D Corporation. All Rights Reserved
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
See LICENSE file and https://dev.perl.org/licenses/
LICENSE
To install MPMinus, copy and paste the appropriate command in to your terminal.
cpanm
cpanm MPMinus
CPAN shell
perl -MCPAN -e shell install MPMinus
For more information on module installation, please visit the detailed CPAN module installation guide.