Comment on How does this pic show that Elon Musk doesnt know SQL?
Geometrinen_Gepardi@sopuli.xyz 1 week ago
Rows in a SQL table have a primary key which works as the unique identifier for that row. The primary key can be as simple as an incrementing number.
DahGangalang@infosec.pub 1 week ago
Right, but if there were multiple entries with the same SSN, wouldnt that be a concern?
knightly@pawb.social 1 week ago
Not unless the data associated with that SSN is itself inconsistent.
For example, when multiple people are fraudulently using the same SSN, the fraud monitoring DB would neccessarily need to record several entries with the same SSN.
DahGangalang@infosec.pub 1 week ago
Ah the old “malware detectors have the selectors for malware and so they show up as malware to other malware detection systems” problem.
Yeah, that seems like a reasonable case to have duplicate SSNs.