Can anyone explain me what are the main difference between a null value and blank value in database. It important please help me out. thank you.
dharam_05
0
Newbie Poster
Recommended Answers
Jump to Post1.A NULL value represents the absence of a value for a record in a field (others softwares call it also a missing value).
2.An empty value is a "field-formatted" value with no significant data in it.
3.NULL isn't allocated any memory, the string with NUll value is just …
Jump to PostGood explanation shanti.
I would also say that null is much easiet to query for than a blank value.
Jump to Postselect * from tablename;
this statement will print all the columns, not the matter of null or empty..
Jump to Postif you need to filter out empty strings
select * from table where length(column) > 0
filter out nulls
select * from table where column is not null
if you need both, just combine
All 15 Replies
Shanti C
106
Posting Virtuoso
dickersonka
104
Veteran Poster
dharam_05
0
Newbie Poster
Shanti C
106
Posting Virtuoso
debasisdas
commented:
agree
+13
dickersonka
104
Veteran Poster
bwagner
Stålhandske
0
Newbie Poster
kamesh.veerachamy
0
Newbie Poster
danielpeterson
-3
Light Poster
kamini_1
0
Newbie Poster
Vinod_11
0
Newbie Poster
cereal
1,524
Nearly a Senior Poster
Featured Poster
prk_1
0
Newbie Poster
cereal
1,524
Nearly a Senior Poster
Featured Poster
jacks009
-10
Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.