Comment on How does this pic show that Elon Musk doesnt know SQL?
Geometrinen_Gepardi@sopuli.xyz 2 weeks 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 2 weeks ago
Right, but if there were multiple entries with the same SSN, wouldnt that be a concern?
knightly@pawb.social 2 weeks 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 2 weeks 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.