blob: 72e2acba0c74fa98535b1e5df48d3ff38cea4b43 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
What you achieve with MysqlPerl
------------------------------
MysqlPerl is an interface between the perl programming language and the
MySQL programming API that comes with the MySQL relational database
management system. All functions provided by the MySQL programming API
are supported.
From perl you activate the interface with the statement
use Mysql;
After that you can connect to multiple msql database servers and send
multiple queries to any of them via an simple object oriented
interface. Two types of objects are available: database handles and
statement handles. Perl returns a database handle to the Connect
method like so:
$dbh = Mysql->connect($hostname,$databasename);
Once you have connected to a database, you get a statement handle
with:
$sth = $dbh->query("select foo from bar");
You can open as many queries as you like simultaneously by selecting a
different scalar to hold the object:
$another_sth = $dbh->Query("select bar from foo");
The statement handle allows you to step through the virtual table
returned from the database with the FetchRow method:
@row = $sth->fetchrow;
or
%hash = $sth->fetchhash;
You can access all metadata that MySQL supplies for a given table. To
find out the number of rows or the number of fields returned by a
query you simply say:
$numrows = $sth->numrows;
$numfields = $sth->numfields;
To find out the size in bytes for the field with the offset 0 (the
first field of a query), you say:
$length = $sth->length->[0];
The list of the names for each column is returned by
@list => $sth->name;
As for other metadata available, consult the manpage that comes with
MysqlPerl and study the examples in the file t/msql.t, which is the
extensive testscript to test your installation, but is heavily
commented, so you may use it as a tutorial.
|
