Re: How to return the value of deleted rows

2001-05-07 Thread Cal Evans
Not having a copy of the MYSQL manual in front of me, I asked my resident M$ SQL expert. He said if there is no built in function, then do a count before, a count after and subtract the two. :) Cal - Original Message - From: "Carlos Fernando Scheidecker Antunes" <[EMAIL PROTECTED]> To:

Re: How to return the value of deleted rows

2001-05-07 Thread Zak Greant
If you are using the C or PHP API, use mysql_affected_rows() If you are working with SQL only, then you will need to issue multiple queries. AFAIK there is no MySQL function to return the number of rows affected. --zak - Original Message - From: "Carlos Fernando Scheidecker Antunes" <[E