Re: affected rows and found rows

2001-11-27 Thread Carl Troein
Ivano Luberti writes: > I would know in what cases "found rows" and "updated rows" could be > different: what i think is that if i get no error code the two number would > be the same, but if the update fails (example key violation) the two number > would be different. >From the manual: "If

affected rows and found rows

2001-11-27 Thread Giuseppe Maxia
> I would know in what cases "found rows" and "updated rows" could be > different: what i think is that if i get no error code the two number would > be the same, but if the update fails (example key violation) the two number > would be different. Try this one, for a simple case: mysql> create

affected rows and found rows

2001-11-27 Thread Ivano Luberti
Hi. i'm new to mysql and for now i'm only studying the manual. Studying the paragraph of the myODBC driver i've found the following phrase: "The client can't handle that MySQL returns the true value of aected rows. If this ag is set then MySQL returns 'found rows' instead." Then in the section