Feature Request: Return number of rows affected by update/delete queries.

[crazyjaco]

Hello.

I recently used WP-CLI to run some SQL queries. After they run, I only got a success or failure message. If it was a success, I did not receive any feedback about how many rows were affected. Running the query directly in MySQL, it lets me know how many rows were affected.

It was would nice to have that metric returned or optionally returned.

Not sure if that would be part of the normal output or added as a new switch.

Thank you for your time.

[schlessera]

Yes, that makes sense and I think it would be a worthwhile improvement.

Would you be up for creating a pull request for this, @crazyjaco ?

[crazyjaco]

I would be interested in that, but I don't have a lot of time to spare in the next week or two. I can look at it after that I think. Would that be alright?

[schlessera]

@crazyjaco Yes, sure. Feel free to ping me when you started to work on it and get stuck!

[lkraav]

I could've used this today in connection with a large DELETE operation https://stackoverflow.com/questions/1318972/deleting-millions-of-rows-in-mysql to do something like

rows_affected = 0
do {
 rows_affected = do_query(
   "DELETE FROM messages WHERE created < DATE_SUB(NOW(),INTERVAL 3 MONTH)
   LIMIT 10000"
 )
} while rows_affected > 0

But can't get "rows affected" from wp db query.