Below sequence shows that MySQL returned 0 rows affected after it deleted 2 records.
Regards,
Gunter
Environment:
W2K,
mysql. 3.23.41-max-nt
mysql> select * from mmecounter;
+----------------------+----------------+-------------+--------------+---------+
----------+------------+-------------+----------+--------+--------+--------+
| ID | Modified | Machine_ref | Category | Name |
ValueNum | ValueFloat | ValueString | DataType | Spare1 | Spare2 | Spare3 |
+----------------------+----------------+-------------+--------------+---------+
----------+------------+-------------+----------+--------+--------+--------+
| -4636453695223307315 | 20011027125508 | 2 | TESTCategory | TestKey |
0 | 0 | TestText | 1 | NULL | NULL | NULL |
| -4636453695223154567 | 20011027125508 | 2 | TESTCategory | TestKey |
0 | 0 | TestText | 1 | NULL | NULL | NULL |
+----------------------+----------------+-------------+--------------+---------+
----------+------------+-------------+----------+--------+--------+--------+
2 rows in set (0.00 sec)
mysql> delete from mmecounter;
Query OK, 0 rows affected (0.00 sec)
mysql> delete from mmecounter where ValueNum=0;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from mmecounter;
Empty set (0.00 sec)
Gunter Leeb
Director of Development
MachineGeneration Inc.
[EMAIL PROTECTED]
Direct: (512) 266 2139
Main: (512) 266 9580
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
