3 ms·
You either have actual NULLs in your tables or you have implied NULLs that don't exist in the actual tables but still come up when you do LEFT JOINs etc. I don
by 6nf 7y ago
You either have actual NULLs in your tables or you have implied NULLs that don't exist in the actual tables but still come up when you do LEFT JOINs etc.
I don't think NULLs are actually a problem in SQL. It's not like we're talking about pointers, it won't cause your server to crash if you use them wrong. NULLs in SQL are fine.
- ben509 7y agoThey're far worse than null pointers. They can cause subtle bugs that lead to queries that appear to work but result in missing or incorrect data.