On Tue, Jun 12, 2001 at 04:47:47PM -0500, Paul DuBois wrote:
>
> Try using:
>
> $dbh->do ("UPDATE ... WHERE k = ?", undef, "xxx")
> and then access $dbh->{mysql_insertid} to see if you get a different
> result. I suspect perhaps not, but it's something to try.
Unfortunately I get the same resu
At 4:34 PM -0500 6/12/01, Erik Rantapaa wrote:
>This really might be a DBI problem, but I find it's pretty weird.
>
>I am attempting to perform atomic updates by using UPDATE statements
>like:
>
> UPDATE counter SET v = last_insert_id(v+1) WHERE k = 'xxx';
>
>where counter has the schema: cr
This really might be a DBI problem, but I find it's pretty weird.
I am attempting to perform atomic updates by using UPDATE statements
like:
UPDATE counter SET v = last_insert_id(v+1) WHERE k = 'xxx';
where counter has the schema: create table counter (k varchar(16) primary key, v int)
