SEO

Hi Experts,

When issuing updates in mysql (in the console window), mysql will tell
you if any rows matched and how many rows were updated (see below). I
know how to get number of rows udpated using mysql_affected_rows(), but is
there any
way to get the number of rows matched? I want to find out, when rows
updated = 0, if there were no updates because the row wasn't found
(rows matched will = 0) or because the update would not have changed
any data (rows matched = 1).

mysql> select * from test;
+------+------+
| roll | s |
+------+------+
| 1 | new |
+------+------+
1 row in set (0.00 sec)

mysql> update test set roll = 1, s = 'new' where roll = 1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

mysql> update test set roll = 1, s = 'new' where roll = 17;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

mysql> update test set roll = 1, s = 'neww' where roll = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

--
Cheers,
Rajan

Hi

AFAIK, before changing data, the old values are saved in the rollback
segment.
On saving the updated values, from the Buffer to the rollback segment/data
files,
--- it checks if there is any matched row that matches the condition. If
found, then flags "Matched".
---after filtering out the matched row, it check whether there is need to
change the old value to new value. if need then flags "Changed" and rewrite
the same in the datafile/rollback segment.


Thanks
ViSolve DB Team.
----- Original Message -----
From: "Ace" <rajan.halade@gmail.com>
To: <mysql@lists.mysql.com>
Sent: Monday, June 11, 2007 11:41 AM
Subject: how to get Number of rows matched?


> Hi Experts,
>
> When issuing updates in mysql (in the console window), mysql will tell
> you if any rows matched and how many rows were updated (see below). I
> know how to get number of rows udpated using mysql_affected_rows(), but is
> there any
> way to get the number of rows matched? I want to find out, when rows
> updated = 0, if there were no updates because the row wasn't found
> (rows matched will = 0) or because the update would not have changed
> any data (rows matched = 1).
>
> mysql> select * from test;
> +------+------+
> | roll | s |
> +------+------+
> | 1 | new |
> +------+------+
> 1 row in set (0.00 sec)
>
> mysql> update test set roll = 1, s = 'new' where roll = 1;
> Query OK, 0 rows affected (0.00 sec)
> Rows matched: 1 Changed: 0 Warnings: 0
>
> mysql> update test set roll = 1, s = 'new' where roll = 17;
> Query OK, 0 rows affected (0.00 sec)
> Rows matched: 0 Changed: 0 Warnings: 0
>
> mysql> update test set roll = 1, s = 'neww' where roll = 1;
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1 Changed: 1 Warnings: 0
>
> --
> Cheers,
> Rajan
>


--------------------------------------------------------------------------------


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.13/843 - Release Date: 6/10/2007
1:39 PM

Ok..thanks! But my problem here is how to check if there were any matched
rows when no rows were changed. mysql_affected_rows() will tell me the
affected rows. Simmly, is there any routine using which one can know if
there were any matched rows?

Cheers,
Rajan

On 6/11/07, ViSolve DB Team <mysqlsupport@visolve.com> wrote:
>
> Hi
>
> AFAIK, before changing data, the old values are saved in the rollback
> segment.
> On saving the updated values, from the Buffer to the rollback segment/data
> files,
> --- it checks if there is any matched row that matches the condition. If
> found, then flags "Matched".
> ---after filtering out the matched row, it check whether there is need to
> change the old value to new value. if need then flags "Changed" and
> rewrite
> the same in the datafile/rollback segment.
>
>
> Thanks
> ViSolve DB Team.
> ----- Original Message -----
> From: "Ace" <rajan.halade@gmail.com>
> To: <mysql@lists.mysql.com>
> Sent: Monday, June 11, 2007 11:41 AM
> Subject: how to get Number of rows matched?
>
>
> > Hi Experts,
> >
> > When issuing updates in mysql (in the console window), mysql will tell
> > you if any rows matched and how many rows were updated (see below). I
> > know how to get number of rows udpated using mysql_affected_rows(), but
> is
> > there any
> > way to get the number of rows matched? I want to find out, when rows
> > updated = 0, if there were no updates because the row wasn't found
> > (rows matched will = 0) or because the update would not have changed
> > any data (rows matched = 1).
> >
> > mysql> select * from test;
> > +------+------+
> > | roll | s |
> > +------+------+
> > | 1 | new |
> > +------+------+
> > 1 row in set (0.00 sec)
> >
> > mysql> update test set roll = 1, s = 'new' where roll = 1;
> > Query OK, 0 rows affected (0.00 sec)
> > Rows matched: 1 Changed: 0 Warnings: 0
> >
> > mysql> update test set roll = 1, s = 'new' where roll = 17;
> > Query OK, 0 rows affected (0.00 sec)
> > Rows matched: 0 Changed: 0 Warnings: 0
> >
> > mysql> update test set roll = 1, s = 'neww' where roll = 1;
> > Query OK, 1 row affected (0.00 sec)
> > Rows matched: 1 Changed: 1 Warnings: 0
> >
> > --
> > Cheers,
> > Rajan
> >
>
>
>
> --------------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.8.13/843 - Release Date: 6/10/2007
> 1:39 PM
>
>

Hi

Simple.. The query "feedback" will depict the matched & changed numbers.
mysql> update test set roll = 1, s = 'new' where roll = 1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0


Thanks
ViSolve DB Team.
----- Original Message -----
From: "Ace" <rajan.halade@gmail.com>
To: "ViSolve DB Team" <mysqlsupport@visolve.com>
Cc: <mysql@lists.mysql.com>
Sent: Monday, June 11, 2007 5:04 PM
Subject: Re: how to get Number of rows matched?


> Ok..thanks! But my problem here is how to check if there were any matched
> rows when no rows were changed. mysql_affected_rows() will tell me the
> affected rows. Simmly, is there any routine using which one can know if
> there were any matched rows?
>
> Cheers,
> Rajan
>
> On 6/11/07, ViSolve DB Team <mysqlsupport@visolve.com> wrote:
>>
>> Hi
>>
>> AFAIK, before changing data, the old values are saved in the rollback
>> segment.
>> On saving the updated values, from the Buffer to the rollback segment/data
>> files,
>> --- it checks if there is any matched row that matches the condition. If
>> found, then flags "Matched".
>> ---after filtering out the matched row, it check whether there is need to
>> change the old value to new value. if need then flags "Changed" and
>> rewrite
>> the same in the datafile/rollback segment.
>>
>>
>> Thanks
>> ViSolve DB Team.
>> ----- Original Message -----
>> From: "Ace" <rajan.halade@gmail.com>
>> To: <mysql@lists.mysql.com>
>> Sent: Monday, June 11, 2007 11:41 AM
>> Subject: how to get Number of rows matched?
>>
>>
>> > Hi Experts,
>> >
>> > When issuing updates in mysql (in the console window), mysql will tell
>> > you if any rows matched and how many rows were updated (see below). I
>> > know how to get number of rows udpated using mysql_affected_rows(), but
>> is
>> > there any
>> > way to get the number of rows matched? I want to find out, when rows
>> > updated = 0, if there were no updates because the row wasn't found
>> > (rows matched will = 0) or because the update would not have changed
>> > any data (rows matched = 1).
>> >
>> > mysql> select * from test;
>> > +------+------+
>> > | roll | s |
>> > +------+------+
>> > | 1 | new |
>> > +------+------+
>> > 1 row in set (0.00 sec)
>> >
>> > mysql> update test set roll = 1, s = 'new' where roll = 1;
>> > Query OK, 0 rows affected (0.00 sec)
>> > Rows matched: 1 Changed: 0 Warnings: 0
>> >
>> > mysql> update test set roll = 1, s = 'new' where roll = 17;
>> > Query OK, 0 rows affected (0.00 sec)
>> > Rows matched: 0 Changed: 0 Warnings: 0
>> >
>> > mysql> update test set roll = 1, s = 'neww' where roll = 1;
>> > Query OK, 1 row affected (0.00 sec)
>> > Rows matched: 1 Changed: 1 Warnings: 0
>> >
>> > --
>> > Cheers,
>> > Rajan
>> >
>>
>>
>>
>> --------------------------------------------------------------------------------
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG Free Edition.
>> Version: 7.5.472 / Virus Database: 269.8.13/843 - Release Date: 6/10/2007
>> 1:39 PM
>>
>>
>


--------------------------------------------------------------------------------


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.13/843 - Release Date: 6/10/2007 1:39 PM

ok...That I know but I need it to check in my code...

On 6/11/07, ViSolve DB Team <mysqlsupport@visolve.com> wrote:
>
> Hi
>
> Simple.. The query "feedback" will depict the matched & changed numbers.
> mysql> update test set roll = 1, s = 'new' where roll = 1;
> Query OK, 0 rows affected (0.00 sec)
> * Rows matched: 1 Changed: 0 Warnings: 0
> *
>
> Thanks
> ViSolve DB Team.
> ----- Original Message ----- From: "Ace" <rajan.halade@gmail.com>
> To: "ViSolve DB Team" <mysqlsupport@visolve.com>
> Cc: <mysql@lists.mysql.com>
> Sent: Monday, June 11, 2007 5:04 PM
> Subject: Re: how to get Number of rows matched?
>
> > Ok..thanks! But my problem here is how to check if there were any
> matched
> > rows when no rows were changed. mysql_affected_rows() will tell me the
> > affected rows. Simmly, is there any routine using which one can know if
> > there were any matched rows?
> >
> > Cheers,
> > Rajan
> >
> > On 6/11/07, ViSolve DB Team <mysqlsupport@visolve.com> wrote:
> >>
> >> Hi
> >>
> >> AFAIK, before changing data, the old values are saved in the rollback
> >> segment.
> >> On saving the updated values, from the Buffer to the rollback
> segment/data
> >> files,
> >> --- it checks if there is any matched row that matches the condition.
> If
> >> found, then flags "Matched".
> >> ---after filtering out the matched row, it check whether there is need
> to
> >> change the old value to new value. if need then flags "Changed" and
> >> rewrite
> >> the same in the datafile/rollback segment.
> >>
> >>
> >> Thanks
> >> ViSolve DB Team.
> >> ----- Original Message -----
> >> From: "Ace" <rajan.halade@gmail.com>
> >> To: <mysql@lists.mysql.com>
> >> Sent: Monday, June 11, 2007 11:41 AM
> >> Subject: how to get Number of rows matched?
> >>
> >>
> >> > Hi Experts,
> >> >
> >> > When issuing updates in mysql (in the console window), mysql will
> tell
> >> > you if any rows matched and how many rows were updated (see below).
> I
> >> > know how to get number of rows udpated using mysql_affected_rows(),
> but
> >> is
> >> > there any
> >> > way to get the number of rows matched? I want to find out, when rows
> >> > updated = 0, if there were no updates because the row wasn't found
> >> > (rows matched will = 0) or because the update would not have changed
> >> > any data (rows matched = 1).
> >> >
> >> > mysql> select * from test;
> >> > +------+------+
> >> > | roll | s |
> >> > +------+------+
> >> > | 1 | new |
> >> > +------+------+
> >> > 1 row in set (0.00 sec)
> >> >
> >> > mysql> update test set roll = 1, s = 'new' where roll = 1;
> >> > Query OK, 0 rows affected (0.00 sec)
> >> > Rows matched: 1 Changed: 0 Warnings: 0
> >> >
> >> > mysql> update test set roll = 1, s = 'new' where roll = 17;
> >> > Query OK, 0 rows affected (0.00 sec)
> >> > Rows matched: 0 Changed: 0 Warnings: 0
> >> >
> >> > mysql> update test set roll = 1, s = 'neww' where roll = 1;
> >> > Query OK, 1 row affected (0.00 sec)
> >> > Rows matched: 1 Changed: 1 Warnings: 0
> >> >
> >> > --
> >> > Cheers,
> >> > Rajan
> >> >
> >>
> >>
> >>
> >>
> --------------------------------------------------------------------------------
> >>
> >>
> >> No virus found in this incoming message.
> >> Checked by AVG Free Edition.
> >> Version: 7.5.472 / Virus Database: 269.8.13/843 - Release Date:
> 6/10/2007
> >> 1:39 PM
> >>
> >>
> >
>
> ------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.8.13/843 - Release Date: 6/10/2007
> 1:39 PM
>

Have you looked at mysql_info()? The format of the return value might not be
the most useful, but it should give you what you need.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com


> -----Original Message-----
> From: ViSolve DB Team [mailto:mysqlsupport@visolve.com]
> Sent: Monday, June 11, 2007 6:15 AM
> To: Ace; mysql@lists.mysql.com
> Subject: Re: how to get Number of rows matched?
>
> Hi
>
> AFAIK, before changing data, the old values are saved in the rollback
> segment.
> On saving the updated values, from the Buffer to the rollback
> segment/data
> files,
> --- it checks if there is any matched row that matches the
> condition. If
> found, then flags "Matched".
> ---after filtering out the matched row, it check whether
> there is need to
> change the old value to new value. if need then flags
> "Changed" and rewrite
> the same in the datafile/rollback segment.
>
>
> Thanks
> ViSolve DB Team.
> ----- Original Message -----
> From: "Ace" <rajan.halade@gmail.com>
> To: <mysql@lists.mysql.com>
> Sent: Monday, June 11, 2007 11:41 AM
> Subject: how to get Number of rows matched?
>
>
> > Hi Experts,
> >
> > When issuing updates in mysql (in the console window),
> mysql will tell
> > you if any rows matched and how many rows were updated (see
> below). I
> > know how to get number of rows udpated using
> mysql_affected_rows(), but is
> > there any
> > way to get the number of rows matched? I want to find out,
> when rows
> > updated = 0, if there were no updates because the row wasn't found
> > (rows matched will = 0) or because the update would not have changed
> > any data (rows matched = 1).
> >
> > mysql> select * from test;
> > +------+------+
> > | roll | s |
> > +------+------+
> > | 1 | new |
> > +------+------+
> > 1 row in set (0.00 sec)
> >
> > mysql> update test set roll = 1, s = 'new' where roll = 1;
> > Query OK, 0 rows affected (0.00 sec)
> > Rows matched: 1 Changed: 0 Warnings: 0
> >
> > mysql> update test set roll = 1, s = 'new' where roll = 17;
> > Query OK, 0 rows affected (0.00 sec)
> > Rows matched: 0 Changed: 0 Warnings: 0
> >
> > mysql> update test set roll = 1, s = 'neww' where roll = 1;
> > Query OK, 1 row affected (0.00 sec)
> > Rows matched: 1 Changed: 1 Warnings: 0
> >
> > --
> > Cheers,
> > Rajan
> >
>
>
> --------------------------------------------------------------
> ------------------
>
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.8.13/843 - Release
> Date: 6/10/2007
> 1:39 PM
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=j...e-infoshop.com
>
>

Yes, you are right! mysql_info() is not most useful. It does give me number
of rows matched but will involve complications of parsing the string.

Is there no other way to this? How can this be missed? I am not so
convinienced on mysql_info()!


On 6/11/07, Jerry Schwartz <jschwartz@the-infoshop.com> wrote:
>
> Have you looked at mysql_info()? The format of the return value might not
> be
> the most useful, but it should give you what you need.
>
> Regards,
>
> Jerry Schwartz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: 860.674.8341
>
> www.the-infoshop.com
> www.giiexpress.com
> www.etudes-marche.com
>
>
> > -----Original Message-----
> > From: ViSolve DB Team [mailto:mysqlsupport@visolve.com]
> > Sent: Monday, June 11, 2007 6:15 AM
> > To: Ace; mysql@lists.mysql.com
> > Subject: Re: how to get Number of rows matched?
> >
> > Hi
> >
> > AFAIK, before changing data, the old values are saved in the rollback
> > segment.
> > On saving the updated values, from the Buffer to the rollback
> > segment/data
> > files,
> > --- it checks if there is any matched row that matches the
> > condition. If
> > found, then flags "Matched".
> > ---after filtering out the matched row, it check whether
> > there is need to
> > change the old value to new value. if need then flags
> > "Changed" and rewrite
> > the same in the datafile/rollback segment.
> >
> >
> > Thanks
> > ViSolve DB Team.
> > ----- Original Message -----
> > From: "Ace" <rajan.halade@gmail.com>
> > To: <mysql@lists.mysql.com>
> > Sent: Monday, June 11, 2007 11:41 AM
> > Subject: how to get Number of rows matched?
> >
> >
> > > Hi Experts,
> > >
> > > When issuing updates in mysql (in the console window),
> > mysql will tell
> > > you if any rows matched and how many rows were updated (see
> > below). I
> > > know how to get number of rows udpated using
> > mysql_affected_rows(), but is
> > > there any
> > > way to get the number of rows matched? I want to find out,
> > when rows
> > > updated = 0, if there were no updates because the row wasn't found
> > > (rows matched will = 0) or because the update would not have changed
> > > any data (rows matched = 1).
> > >
> > > mysql> select * from test;
> > > +------+------+
> > > | roll | s |
> > > +------+------+
> > > | 1 | new |
> > > +------+------+
> > > 1 row in set (0.00 sec)
> > >
> > > mysql> update test set roll = 1, s = 'new' where roll = 1;
> > > Query OK, 0 rows affected (0.00 sec)
> > > Rows matched: 1 Changed: 0 Warnings: 0
> > >
> > > mysql> update test set roll = 1, s = 'new' where roll = 17;
> > > Query OK, 0 rows affected (0.00 sec)
> > > Rows matched: 0 Changed: 0 Warnings: 0
> > >
> > > mysql> update test set roll = 1, s = 'neww' where roll = 1;
> > > Query OK, 1 row affected (0.00 sec)
> > > Rows matched: 1 Changed: 1 Warnings: 0
> > >
> > > --
> > > Cheers,
> > > Rajan
> > >
> >
> >
> > --------------------------------------------------------------
> > ------------------
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.5.472 / Virus Database: 269.8.13/843 - Release
> > Date: 6/10/2007
> > 1:39 PM
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=j...e-infoshop.com
> >
> >
>
>

Thanks All for your help!

If someone from MySQL team is looking at this mail thread, we request to
include this feature in future release.

Cheers,
Rajan
On 6/11/07, Michael Dykman <mdykman@gmail.com> wrote:
>
> no, there is nothing else. There are cleaner interfaces to this
> information but, for PHP. the string returned by mysql_info() is all
> you get. The format of that string is very regular and we have been
> using it in production software for well over a year now with no
> issues.
>
> - michael
>
>
> On 6/11/07, Ace <rajan.halade@gmail.com> wrote:
> > Yes, you are right! mysql_info() is not most useful. It does give me
> number
> > of rows matched but will involve complications of parsing the string.
> >
> > Is there no other way to this? How can this be missed? I am not so
> > convinienced on mysql_info()!
> >
> >
> > On 6/11/07, Jerry Schwartz <jschwartz@the-infoshop.com> wrote:
> > >
> > > Have you looked at mysql_info()? The format of the return value might
> not
> > > be
> > > the most useful, but it should give you what you need.
> > >
> > > Regards,
> > >
> > > Jerry Schwartz
> > > The Infoshop by Global Information Incorporated
> > > 195 Farmington Ave.
> > > Farmington, CT 06032
> > >
> > > 860.674.8796 / FAX: 860.674.8341
> > >
> > > www.the-infoshop.com
> > > www.giiexpress.com
> > > www.etudes-marche.com
> > >
> > >
> > > > -----Original Message-----
> > > > From: ViSolve DB Team [mailto:mysqlsupport@visolve.com]
> > > > Sent: Monday, June 11, 2007 6:15 AM
> > > > To: Ace; mysql@lists.mysql.com
> > > > Subject: Re: how to get Number of rows matched?
> > > >
> > > > Hi
> > > >
> > > > AFAIK, before changing data, the old values are saved in the
> rollback
> > > > segment.
> > > > On saving the updated values, from the Buffer to the rollback
> > > > segment/data
> > > > files,
> > > > --- it checks if there is any matched row that matches the
> > > > condition. If
> > > > found, then flags "Matched".
> > > > ---after filtering out the matched row, it check whether
> > > > there is need to
> > > > change the old value to new value. if need then flags
> > > > "Changed" and rewrite
> > > > the same in the datafile/rollback segment.
> > > >
> > > >
> > > > Thanks
> > > > ViSolve DB Team.
> > > > ----- Original Message -----
> > > > From: "Ace" <rajan.halade@gmail.com>
> > > > To: <mysql@lists.mysql.com>
> > > > Sent: Monday, June 11, 2007 11:41 AM
> > > > Subject: how to get Number of rows matched?
> > > >
> > > >
> > > > > Hi Experts,
> > > > >
> > > > > When issuing updates in mysql (in the console window),
> > > > mysql will tell
> > > > > you if any rows matched and how many rows were updated (see
> > > > below). I
> > > > > know how to get number of rows udpated using
> > > > mysql_affected_rows(), but is
> > > > > there any
> > > > > way to get the number of rows matched? I want to find out,
> > > > when rows
> > > > > updated = 0, if there were no updates because the row wasn't found
> > > > > (rows matched will = 0) or because the update would not have
> changed
> > > > > any data (rows matched = 1).
> > > > >
> > > > > mysql> select * from test;
> > > > > +------+------+
> > > > > | roll | s |
> > > > > +------+------+
> > > > > | 1 | new |
> > > > > +------+------+
> > > > > 1 row in set (0.00 sec)
> > > > >
> > > > > mysql> update test set roll = 1, s = 'new' where roll = 1;
> > > > > Query OK, 0 rows affected (0.00 sec)
> > > > > Rows matched: 1 Changed: 0 Warnings: 0
> > > > >
> > > > > mysql> update test set roll = 1, s = 'new' where roll = 17;
> > > > > Query OK, 0 rows affected (0.00 sec)
> > > > > Rows matched: 0 Changed: 0 Warnings: 0
> > > > >
> > > > > mysql> update test set roll = 1, s = 'neww' where roll = 1;
> > > > > Query OK, 1 row affected (0.00 sec)
> > > > > Rows matched: 1 Changed: 1 Warnings: 0
> > > > >
> > > > > --
> > > > > Cheers,
> > > > > Rajan
> > > > >
> > > >
> > > >
> > > > --------------------------------------------------------------
> > > > ------------------
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG Free Edition.
> > > > Version: 7.5.472 / Virus Database: 269.8.13/843 - Release
> > > > Date: 6/10/2007
> > > > 1:39 PM
> > > >
> > > >
> > > > --
> > > > MySQL General Mailing List
> > > > For list archives: http://lists.mysql.com/mysql
> > > > To unsubscribe:
> > > > http://lists.mysql.com/mysql?unsub=j...e-infoshop.com
> > > >
> > > >
> > >
> > >
> >
>
>
> --
> - michael dykman
> - mdykman@gmail.com
>
> - All models are wrong. Some models are useful.
>

At 11:11 PM -0700 6/10/07, Ace wrote:
>Hi Experts,
>
>When issuing updates in mysql (in the console window), mysql will tell
>you if any rows matched and how many rows were updated (see below). I
>know how to get number of rows udpated using mysql_affected_rows(), but is
>there any
>way to get the number of rows matched? I want to find out, when rows
>updated = 0, if there were no updates because the row wasn't found
>(rows matched will = 0) or because the update would not have changed
>any data (rows matched = 1).

Pass the CLIENT_FOUND_ROWS flag value to mysql_real_connect() when
you connect to the server.

http://dev.mysql.com/doc/refman/5.0/...l-connect.html

>
>mysql> select * from test;
>+------+------+
>| roll | s |
>+------+------+
>| 1 | new |
>+------+------+
>1 row in set (0.00 sec)
>
>mysql> update test set roll = 1, s = 'new' where roll = 1;
>Query OK, 0 rows affected (0.00 sec)
>Rows matched: 1 Changed: 0 Warnings: 0
>
>mysql> update test set roll = 1, s = 'new' where roll = 17;
>Query OK, 0 rows affected (0.00 sec)
>Rows matched: 0 Changed: 0 Warnings: 0
>
>mysql> update test set roll = 1, s = 'neww' where roll = 1;
>Query OK, 1 row affected (0.00 sec)
>Rows matched: 1 Changed: 1 Warnings: 0
>
>--
>Cheers,
>Rajan


--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com