[mongoloid001]

Hey, I have a table called sentence_grammar, which has gramma_id, subject, verb, noun, adjective, adverb, ...

This is how it works: for example, if you have a sentence 'I love dbforums,' it will match to the grammar_id having

subject assigned number 1
verb assigned number 2
noun assgned number 3

And the rest assigned...

That's my question, null or 0, which is better? And why?

Thanks!

[eperich]

I think 0 ist better

When you have null you must do a select afterwards

SELECT * FROM xxx WHERE y < 2

the nulls are not counted in some circumstances

it is always better to use not null