Re: IS NULL Question

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

Re: IS NULL Question

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

Re: IS NULL Question

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

RE: IS NULL Question

t; Cc: MySQL List > Subject: Re: IS NULL Question > > 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 mea

Re: IS NULL Question

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

Re: IS NULL Question

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

Re: IS NULL Question

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

Re: IS NULL Question

> 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

Re: IS NULL Question

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

IS NULL Question

I'm having problems understanding NULL. I grasp what a NULL value is, but I can't get NULL to perform correctly. For instance, if I do a Select statement, I see that I have columns with a NULL value. select first, last, suffix from persons LIMIT 5; +---+--++ | first |