In the last episode (Jul 20), David Wall said:
> > This is exactly correct, if you had read the manual it would have
> > told you it returns 0 rows affected.
>
> That may not have been his real problem, but rather WHY does it do
> it? If you updated all rows, it would show that, so why does
> deleting them cause them to not be counted?
Because when you delete all rows, mysql simply truncates the datafile
and indexes. There is no need for the server to fetch a rowcount, so
it doesn't.
-Dan Nelson
dnelson@stripped
