List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:October 16 1999 11:15am
Subject:Re: DELETE not deleting all records.
View as plain text  
Milton writes:
 > Trying 3.21.29 for NT.  Have test table with 300k records with primary key
 > on 4 cols.  On connected client (user=root), I issue delete from table where
 > company='HHH'.  The result suppose to delete all but 1 record.  mysql
 > returns 27k records affected. hmm?  Repeated the same command.  mysql
 > returns 68k records affected.  hmm.hmm?  I now go on to the host
 > (localhost/root) and issue the same delete command.  Works fine and deletes
 > all the records.  Could not find anything in the docs or change hist re this
 > problem.  Anybody got any clue?  PS. The client had no problem inserting and
 > updating the 300k records.
 > 
 > 
 > 
 > 
 > 

What client have you used to delete rows from other machine ??

If it is some ODBC-based client, then it is possible that you have
some bug in that client or ODBC setup. 

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
Thread
DELETE not deleting all records.Milton16 Oct
  • Re: DELETE not deleting all records.sinisa16 Oct
Re: DELETE not deleting all records.Milton17 Oct
  • Re: DELETE not deleting all records.Michael Widenius18 Oct