List:General Discussion« Previous MessageNext Message »
From:Evert Date:August 26 2006 7:28am
Subject: Why can't I delete these records?
View as plain text  
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

Thread
Why can't I delete these records?Evert26 Aug
  • Re: Why can't I delete these records?Aleksandar Bradaric26 Aug
    • Re: Why can't I delete these records?Evert26 Aug
      • Re: Why can't I delete these records?Rocco26 Aug
        • Re: Why can't I delete these records?Evert26 Aug
          • Re: Why can't I delete these records?Rocco26 Aug
            • Re: Why can't I delete these records?Evert26 Aug
              • Re: Why can't I delete these records?Rocco26 Aug
                • Re: Why can't I delete these records?Evert26 Aug
                  • Re: Why can't I delete these records?Michael Stassen27 Aug
                    • Re: Why can't I delete these records?Evert Meulie28 Aug
                      • Re: Why can't I delete these records?Joerg Bruehe28 Aug
                        • Re: Why can't I delete these records?Evert Meulie28 Aug