When UPDATE doesn't work.. - MySQL

[Occidental]

eg

UPDATE MyTable SET SomeField = 20 WHERE AnotherField = -1

If the table MyTable has no record with AnotherField = -1, obviously no
update will take place, and the query will end normally. Is there any
way to capture the fact that no update has taken place (other than the
obvious trick of determining prior to the update whether AnotherField =
-1 exists)?

[Jerry]

Occidental wrote: 

Depending on the language you're using, you can get the affected rows.
For instance, in PHP it's mysql_affected_rows().

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
net
==================

[Lee]

On Fri, 15 Sep 2006 18:22:14 -0400, Jerry Stuckle
<net> wrote:
 
>
>Depending on the language you're using, you can get the affected rows.
>For instance, in PHP it's mysql_affected_rows().[/ref]

In Rexx, it's sqlca.rowcount

Lee

[Dikkie]

>> eg 
>
> Depending on the language you're using, you can get the affected rows.
> For instance, in PHP it's mysql_affected_rows().[/ref]

Beware though, that the rows where SomeField was already 20 do not count
as "affected".

Best regards

[Norman]

Dikkie Dik wrote: 
>>
>> Depending on the language you're using, you can get the affected rows.
>> For instance, in PHP it's mysql_affected_rows().[/ref]
>
> Beware though, that the rows where SomeField was already 20 do not count
> as "affected".
>
> Best regards[/ref]

Well, they don't have anything to do with the query to begin with.

Norm

[Captain]

On 22 Feb, 10:58, Norman Peelman <rr.com> wrote: 

Why don't they?