Re: delete where column <=> null

2002-11-19 Thread Peter Brawley
es below using <=>, the > records containing NULL *are* deleted. I'm not sure why David is observing > different behavior. > > > > >-Original Message- > >From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]] > >Sent: Tuesday, November 19, 2002 12:26 PM

Re: delete where column <=> null

2002-11-19 Thread Benjamin Pflugmann
Hi. On Tue 2002-11-19 at 12:38:33 -0500, [EMAIL PROTECTED] wrote: > Nothing can be compared to null, not even null, which implies that MySQL is > wrong in returning two rows in the SELECT. I have to disagree. The "<=>" operator is explicitly defined to allow that. "<=>" is the same as "=", except

RE: delete where column <=> null

2002-11-19 Thread Paul DuBois
Tuesday, November 19, 2002 12:26 PM To: [EMAIL PROTECTED] Cc: '[EMAIL PROTECTED]' Subject: RE: delete where column <=> null David, I get the same behaviour with mysql 3.23.47 (not max) and with mysql v 4.0.4-beta Without the index it works fine. Must be a bug Cheer

RE: delete where column <=> null

2002-11-19 Thread Andrew Braithwaite
ember 2002 17:39 To: Andrew Braithwaite; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: delete where column <=> null Nothing can be compared to null, not even null, which implies that MySQL is wrong in returning two rows in the SELECT. Your query needs to say IS NULL: delete from t wher

RE: delete where column <=> null

2002-11-19 Thread Arthur Fuller
: Tuesday, November 19, 2002 12:26 PM To: [EMAIL PROTECTED] Cc: '[EMAIL PROTECTED]' Subject: RE: delete where column <=> null David, I get the same behaviour with mysql 3.23.47 (not max) and with mysql v 4.0.4-beta Without the index it works fine. Must be a bug Cheers, Andre

RE: delete where column <=> null

2002-11-19 Thread Chung Ha-nyung
You should use "IS NULL" or "IS NOT NULL" query. -- Chung Ha-nyung SayClub NeoWiz > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 20, 2002 1:45 AM > To: [EMAIL PROTECTED] > Subje

RE: delete where column <=> null

2002-11-19 Thread Andrew Braithwaite
David, I get the same behaviour with mysql 3.23.47 (not max) and with mysql v 4.0.4-beta Without the index it works fine. Must be a bug Cheers, Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 November 2002 16:45 To: [EMAIL PROTECTED] Subject: