title: How do I count the number of deleted rows in a MYSQL query?
body: <p>I'm trying to find out whether a delete query executed properly. I know how many rows its supposed to delete, and I'd like to check that the number that were deleted, matches what's expected, from within the query itself.</p>
  
  <p>How do I find out the number of rows that I just deleted, <strong>from within a SQL query</strong> running against MySQL? Separate statements are fine, as long as I can bundle them into one query.</p>