Gossamer Forum
Home : Products : DBMan : Installation :

What does 'not_null' mean?

Quote Reply
What does 'not_null' mean?
Okay, laugh at me. Go ahead. It's my first true databasing attempt, using anything like this. So help me out. What's it mean? What's it do? Particularly in the Database Definition area.

Quote Reply
Re: What does 'not_null' mean? In reply to
Let's break up the words...

not is http://www.m-w.com/cgi-bin/dictionary?not

null is http://www.m-w.com/cgi-bin/dictionary?null

Therefore, with null being null, nada, nothing, etc. and NOT being a negative value. This means that the field must contain something, have value, be something, etc.

not null = have a value in it
null = does not have to a value in it

Hope this helps! I've found the dictionary to be quite helpful when learning new languages, like Perl...

Regards,

Eliot Lee
Quote Reply
Re: What does 'not_null' mean? In reply to
Oh man, I'm dumb. I thought it was something much more complex that than that. Thanks for your help.

Quote Reply
Re: What does 'not_null' mean? In reply to
Most commands and functions within databases and Languages, like Perl, are intuitive if you spend time deciphering their meaning...

Example:

&& or and in Perl means just that...

Condition 1 and Condition 2 must be met in order to do something.

Regards,

Eliot Lee