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
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 mysql@lists.mysql.com
cc
Subject
Re: IS NULL Question
I'm having
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
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.
.
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
Cc: MySQL List
Subject: Re: IS NULL
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 (
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
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
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 NULL
I'm really just currious as to WHAT you would want to see as opposed
to NULL?
How could you have a field that has no value? What would it mean?
NULL is the answer to this. It is recording the absence of
something. So, I would say that this is an expected behaviour of any
database
Hi.
On Wed 2003-01-22 at 23:07:24 -0800, [EMAIL PROTECTED] wrote:
I'm really just currious as to WHAT you would want to see as opposed
to NULL?
Well, you asking the wrong guy, because I did not need that feature,
but I'll try to explain anyhow.
They want to see an error instead. It is the
On Wednesday 15 January 2003 22:36, Gabe Geisendorfer wrote:
Thanks, I check it out.. Any idea if this 'deficiency' is scheduled to
change?
Yes.
http://www.mysql.com/doc/en/TODO_future.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
Hello.
On Tue 2003-01-14 at 09:32:02 -0800, [EMAIL PROTECTED] wrote:
I'm aware that NULL and are not the same thing.. I would like to
prevent the column from accepting values automatically ( with out the
presence of a DEFAULT).
[...]
The problem is: You have a DEFAULT, you just don't know
Thanks, I check it out.. Any idea if this 'deficiency' is scheduled to
change?
Thanks,
Gabe
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 9:49 AM
To: Gabe Geisendorfer
Cc: [EMAIL PROTECTED]
Subject: Re: NOT NULL question
14 matches
Mail list logo