Skip site navigation (1) Skip section navigation (2)

Re: How to retrieve how many rows are affected after doing an INSERT statement

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: How to retrieve how many rows are affected after doing an INSERT statement
Date: 2005-04-13 02:00:34
Message-ID: efaafe2b936b90461940846fd5268fbf@biglumber.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
-----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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200504122200
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFCXH1TvJuQZxSWSsgRAtmzAKDWF3HFWNDl0ITAB/vJkdSSBjW2nACfWqXA
vqi47yulZB40WF7w6WuibeQ=
=QI53
-----END PGP SIGNATURE-----



In response to

pgsql-interfaces by date

Next:From: Brian TrammellDate: 2005-04-13 19:04:57
Subject: DBD::Pg and .pgpass
Previous:From: Michael FuhrDate: 2005-04-12 15:56:40
Subject: Re: How to retrieve how many rows are affected after doing an INSERT statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group