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 |
+----------------------------------------------------------------------+