List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 20 1999 10:36pm
Subject:Re: Win95 version Mysql
View as plain text  
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
Win95 version Mysqlhuizinga21 Jul
Re: Win95 version MysqlKevin Smith21 Jul
Re: Win95 version MysqlPaul DuBois21 Jul
Re: Win95 version MysqlDavid Wall21 Jul
  • Re: Win95 version MysqlDan Nelson21 Jul
  • Re: Win95 version MysqlPaul DuBois21 Jul