Thread: How to retrieve how many rows are affected after doing an INSERT statement
Hello,
When we use PostgreSQL with Perl, we can retrieve
Error messages from database handler, say, if my
database handler is presented as $dbh, then I use
$dbh->errstr() can get error message like:
ERROR: Cannot insert a duplicate key into unique index
a_dbtable_pkey.
Is there a way to retriever from $dbh how many rows
are affected after doing an insert statement, and how
to present this?
I tried $dbh->rowcount(), it doesn't work, So what's
the exact expression?
Any help will be appreciated.
jing
__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail
Re: How to retrieve how many rows are affected after doing an INSERT statement
From
Michael Fuhr
Date:
On Tue, Apr 12, 2005 at 08:41:24AM -0700, jing han wrote: > > Is there a way to retriever from $dbh how many rows > are affected after doing an insert statement, and how > to present this? See the DBI documentation (e.g., "perldoc DBI") and search for "rows" or "number of rows". -- Michael Fuhr http://www.fuhr.org/~mfuhr/
Re: How to retrieve how many rows are affected after doing an INSERT statement
From
"Greg Sabino Mullane"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> Is there a way to retriever from $dbh how many rows
> are affected after doing an insert statement, and how
> to present this?
You can grab it directly from the execute, or use the rows() method:
$sth = $dbh->prepare("INSERT INTO mytable SELECT * FROM mytable");
$count = $sth->execute();
print "Count is $count\n";
$count = $sth->rows;
print "Count is still $count\n";
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200504122200
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iD8DBQFCXH1TvJuQZxSWSsgRAtmzAKDWF3HFWNDl0ITAB/vJkdSSBjW2nACfWqXA
vqi47yulZB40WF7w6WuibeQ=
=QI53
-----END PGP SIGNATURE-----