PERL Beginners - Re: dbi

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: dbi - 0E0

Paul Lalli

2006-02-21, 6:57 pm

gandalf100@gmail.com wrote:
> if i have an update query say:
> UPDATE mydb SET mail='naom222' WHERE id='1'
> what the result will be ,0 or 0E0

0 or '' or undef on an error

0E0 on success, but no rows matching id=1

> and what will it be if we found it but rhe value of mail has not been
> changed

IIRC, update makes no notice of whether any rows affected by the UPDATE
actually already had the given values passed to SET. This would have
no effect. If there are three rows where id = 1, you will get a result
of 3, regardless of how many of those rows have a mail = 'naom222'

Paul Lalli

Sponsored Links