A database concept used to represent missing, unknown or inapplicable data.

learn more… | top users | synonyms

1
vote
0answers
44 views

How to merge rows based on how much data they have?

I am cleaning data and I formed a table something like this: file | product | color | product_id --------------------------------------------- one.csv pipe blue null ...
1
vote
0answers
28 views

Dealing with null values in non-nullable columns in a NoSQL database

If I have an existing table in a NoSQL database cluster and I want to add a new column that should never return null, how do I handle it in my application code? I can update all exist records and ...
0
votes
0answers
30 views

MySQL - query join returning zero recs from table with data

I've provided a file that has the table structure and some sample data that I'm working with. I don't understand why I'm getting nulls from a joined table, where there is data. Here's my query ...
0
votes
0answers
113 views

Database associative table

I have a coworker who's insisting on using associative tables to create nullable associations. For example, we have this table : cm.accounts ---------- id:int (PK, identity) ... sm.services ...