It looks like it was a string named NULL posing as a null value.
I got 0 for ISNULL(suffix), which I assume means false. I tried this
command ...
update persons set suffix = 'Empty' where suffix = '';
It changed the NULLs to Empty.
On Mon, 2007-04-30 at 18:12 -0700, Jeremy Cole wrote:
> Hi Joh
Jerry Schwartz wrote:
We use NULL all the time with MyISAM tables, and I've never noticed a
problem.
I think there was a bug at one point dealing with NULL and empty
strings, but it strikes me that it was a bug in the new client/server
protocol that was introduced in (4.1? 5.0?).
So, it mig
Caveat emptor: I haven't tested this in about a year.
Are you perchance using a table type of MyISAM? I seem to recall
that MyISAM has a hard time actually representing NULL
internally. [ ... Thinks for a minute ... ] I remember
something about spaces, like, I think I did
INSERT ( val
me a devil of a time.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Kevin Hunter [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 01, 2007 11:37 AM
> To: John Kebbel
&g
Kevin Hunter wrote:
At 9:06p -0400 on 30 Apr 2007 John Kebbel wrote:
I'm having problems understanding NULL. I grasp what a NULL value is,
A NULL value is rather an oxymoron. It'd be more accurate to say that
NULL means "absence of a value".
but I can't get NULL to perform correctly. F
At 9:06p -0400 on 30 Apr 2007 John Kebbel wrote:
I'm having problems understanding NULL. I grasp what a NULL value is,
A NULL value is rather an oxymoron. It'd be more accurate to say
that NULL means "absence of a value".
but I can't get NULL to perform correctly. For instance, if I do a
By chance when you set them as null did you use "null" or 'null' setting
it as a string value?
__
Lucas Heuman
Phone 609.485.5401
"Martijn Tonies" <[EMAIL PROTECTED]>
05/01/2007 04:45 AM
To
"MySQL"
cc
Subject
Re: I
> I'm having problems understanding NULL. I grasp what a NULL value is,
Actually, you don't :-)
NULL is not a value, it's the lack of value and a state.
A column can have 2 states: NULL or NOT NULL, which is part
of the reason why SQL allows for the IS NULL and IS NOT NULL
clause as opposed t
Hi John,
Are you sure they are actually NULL and not "NULL" (i.e. the string "NULL")?
Try this:
SELECT first, last, ISNULL(suffix), LENGTH(suffix) FROM persons LIMIT 5;
Regards,
Jeremy
John Kebbel wrote:
I'm having problems understanding NULL. I grasp what a NULL value is,
but I can't get N
