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" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, May 07, 2001 2:01 PM
Subject: How to return the value of deleted rows
Hello Folks,
I wonder how can I return the number of deleted rows after a DELETE SQL
statement.
Is there any way to return the quantity of updated rows as well?
Thanks,
C.F.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
