How to return the value of deleted rows

[Carlos Fernando Scheidecker Antunes]

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.

Re: How to return the value of deleted rows

[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: MySQL List [EMAIL PROTECTED]
Sent: Monday, May 07, 2001 3: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