Hi all!
I got it to work! :-)
And all I did was replacing IS NULL with = '-00-00 00:00:00' in
the DELETE-statement...
Does anyone have an explanation for this...?
Regards,
Evert
Michael Stassen wrote:
Evert wrote:
Hi all!
Who can tell me why the following does not work...?
When
I'll double-check it on another MySQL server I have here (uses same
version of MySQL) and will file a bug report if I indeed can replicate
the problem.
Thank you all for the swift replies! :-)
Regards,
Evert
Joerg Bruehe wrote:
Hi Evert, all!
Evert Meulie wrote (re-ordered):
Michael
= '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
DELETE doesn't work?
Regards,
Evert
Aleksandar Bradaric wrote:
Hi,
Query OK, 0 rows affected (0.00 sec)
It did not find/delete any rows - please double-check your
conditions and make sure you are using the same set as for
the SELECT statement.
Best regards,
Aleksandar
--
MySQL
I'm using MySQL 4.1.21 (on Gentoo). Should this make any difference?
Regards,
Evert
Rocco wrote:
Hello Evert,
i just entered your example and had no unusal behaviour on MySQL 5.0:
mysql describe table1;
+++--+-+-+---+
| Field | Type
Hi!
I tried your tip, but = gives the same result as = when I execute the
query... :-/
Regards,
Evert
Rocco wrote:
Hello Evert,
i actually do not know and don't have access to a 4.1 Machine. What you
could try is to use the alternative way of testing if a value is NULL:
Maybe
Oops, that was just a typo in my previous reply. My script does use 'IS
NULL' and not '= NULL'. I also tried '= NULL'. No luck...
Evert
Rocco wrote:
Hello Evert,
the = Operator can not work with NULL values , so you have to use = or
IS NULL. I have no clue why its not working at your