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
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!
>>
>&
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 N
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:
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
hy my 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
= '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 Mailin
