There's data missing - please explain

Posted by Bob_Mesibov on Jun 30, 2021 2:57 AM EDT
BASHing data
Mail this story
Print this story

What should data enterers do about missing data? The database software might only help a little. For example, MySQL users enter "NULL" whenever a data item doesn't have a known value. NULL gets special treatment in MySQL: it's ignored, or understood to equal FALSE. An empty string can also be a data item in MySQL, and it's treated differently from NULL. An empty string is known to be a blank, while NULL isn't known to be anything. But does blank really mean blank?

Full Story

  Nav
» Read more about: Story Type: Tutorial; Groups: Linux

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.