Solved

count

Posted on 2000-04-23
5
124 Views
Last Modified: 2010-03-05
how can I get the total number of records in a table of a database?
i would like to use PERL, DBI.
any one can provide me a simple source code?

0
Comment
Question by:stanleyhuen
  • 3
5 Comments
 

Accepted Solution

by:
yovavm101799 earned 10 total points
ID: 2741744
1. Connect to your DB.

2. Perform a 'select* from Table'

3. Get the meta-data $DBI::rows
This variable holds the number of rows affected or returned by the last executed statement

Sample:
------
use DBI;
$dbname = 'DEMO'; $user = 'admin';
$password = 'pass'; $dbd = 'Oracle';

$dbh = DBI->connect($dbname,$user,$password,$dbd) ||
       die "Error connecting $DBI::errstr\n";;


$sth = $dbh->prepare("Select * from Customers");
if ($DBI::err) {
  die STDERR "$DBI::errstr\n";
}
$sth->execute() ;
if ($DBI::err) {
  die STDERR "$DBI::errstr\n";
}
$numOfRecs = $DBI::rows;
print "Total records in table: Customer is $numOfRecs\n";


0
 

Expert Comment

by:mwhuen
ID: 2741967
besides  $DBI::rows, $DBI::err, $DBI::errstr, any other useful functions of DBI?
where can I get more information of these useful functions?
0
 

Expert Comment

by:yovavm101799
ID: 2743055
In case you mean MetaData, well here are some methods used to obtain Meta Data:

$dbh->tables()
fetch a list of all accessible table names

$DBI::rows
The number of rows affected or returned

After executing the statement, use the statement handle to get:

$sth->{NUM_FIELDS}
The number of fields returned by a select

$sth->{NUM_PARAMS}
The number of parameters returned by any query

After a select query, the following attributes contain references to arrays of field-specific information:

$sth->{NAME}
Column names returned by the query

$sth->{NULLABLE}
Booleans indicating whether fields are nullable or not

$sth->{TYPE}
Field types

$sth->{PRECISION}
Floating-point precision of field

$sth->{SCALE}
Field lengths

0
 

Author Comment

by:stanleyhuen
ID: 2744498
thanks yovavm,

i would like to learn more about DBI?

do u know any good resources of DBI?
0
 

Expert Comment

by:yovavm101799
ID: 2746477
Check: "Advanced Perl Programming", By Sriram Srinivasan, published by O'Reilly & Associates.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This is an introductory video for CloudBerry Managed Backup. You will learn how to sign up with the service and get started in a few minutes.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now