Hi all!
Who can tell me why the following does not work...?
When I do:
SELECT COUNT(*) AS counter FROM table1 WHERE condition1 = 'A' AND
condition2 IS NULL;
it returns:
+---------+
| counter |
+---------+
| 2 |
+---------+
Then I do:
DELETE FROM table1 WHERE condition1 = 'A' AND condition2 IS NULL;
it returns:
Query OK, 0 rows affected (0.00 sec)
But... when I give a
SELECT COUNT(*) AS counter FROM table1 WHERE condition1 = 'A' AND
condition2 IS NULL;
How come the 2 records did not get deleted...?
Regards,
Evert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]