Re: delete returns incorect number of deleted rows.

[Ed Carp]

>The manual clearly states that when deleting all rows MySQL recreates
>the table as an empty table and can therefor not know how many rows that
>were affected. It's not an bug, it's a feature.


I've noticed this myself.  It's easy enough to fix, I would think - "echo
$query|sed -e 's/delete/select count(*)/g'|mysql $database" immediately
comes to mind.  In C, save whatever mysql_num_rows() returns, do the delete,
then return the saved number.