| Author |
Topic |
|
Jillsy
Starting Member
20 Posts |
 Posted - 2006-01-26 : 10:41:22
|
| HiI have a table with 6 columns, when i insert a row only 2 of the fields have data and the other 4 are NULL. The fields with NULL values are updated with data at a later time. Are there any issues with having a table two-thirds full of NULL fields?Jill |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-26 : 11:07:12
|
| No |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-01-26 : 11:18:23
|
| Jill,Did you really do all the designs for Wookey Hole?Went up there for the first time a few weeks ago, even though I only live an hour away..Oh, and your question has been answered.. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-26 : 14:54:26
|
To me NULL means "Not yet known, or will never be known"Its different to Blank or Zero. That means we know, and its blank. Like the third line of someones address. But a blank telephone number would tell me they don't have one [seems unlikely] rather than "they didn't tell us what it is, yet"I've probably over simplified it and will get roasted by my fellow SQL Teamers ...  Kristen |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-01-26 : 17:10:30
|
quote:
Originally posted by Kristen
To me NULL means "Not yet known, or will never be known"Its different to Blank or Zero. That means we know, and its blank. Like the third line of someones address. But a blank telephone number would tell me they don't have one [seems unlikely] rather than "they didn't tell us what it is, yet"I've probably over simplified it and will get roasted by my fellow SQL Teamers ... Kristen
Very true.And you cant compare two columns of null values with one another |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-01-26 : 17:28:50
|
which part?  Go with the flow & have fun! Else fight the flow  |
|
|
|
Jillsy
Starting Member
20 Posts |
Posted - 2006-01-26 : 17:43:19
|
| RickD, I didn't do all the designs for Wookey Hole, most of them were another guys work who draw the outline and i painted in the detail. The dinosaurs were scrounged from all over the place but i scrubbed them up and again painted on the detail. Nice that you checked out my website, any comments about that?Jill |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-27 : 00:49:27
|
>>To me NULL means "Not yet known, or will never be known"or may be updated soon  MadhivananFailing to plan is Planning to fail |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-01-27 : 03:30:40
|
| Hey Jill - with a CV like that can't you just pay someone to sort out a database for you. Steve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-01-27 : 12:16:27
|
quote:
Originally posted by Jillsy
RickD, I didn't do all the designs for Wookey Hole, most of them were another guys work who draw the outline and i painted in the detail. The dinosaurs were scrounged from all over the place but i scrubbed them up and again painted on the detail. Nice that you checked out my website, any comments about that?Jill
It's quite a nice design, after looking around for a bit, the only bug-bear is that going back just goes back to the last pic you looked at (which means all the pics are loaded in seperate pages). Would be better if it went back to the last page you looked at instead..Other than that, it is pretty clear and concise.. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-28 : 01:54:24
|
| "with a CV like that can't you just pay someone to sort out a database for you"Yeah, we all know you're available Steve, but Jill will be looking for someone GOOD eh? <vbg>Kristen |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-01-28 : 17:30:37
|
| Are there any issues with having a table two-thirds full of NULL fields?Put all fields to not null, and discover where the business process and data model can be improved.rockmoose |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-01-30 : 03:16:49
|
quote:
Yeah, we all know you're available Steve, but Jill will be looking for someone GOOD
Kristen - depends on your definition of GOOD -----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-30 : 03:33:33
|
| Well ... I wasn't thinking of the opposite of Naughty!Kristen |
|
|
|
|
NULL