I’m a tech interested guy. I’ve touched SQL once or twice, but wasn’t able to really make sense of it. That combined with not having a practical use leaves SQL as largely a black box in my mind (though I am somewhat familiar with technical concepts in databasing).

With that, I keep seeing [pic related] as proof that Elon Musk doesn’t understand SQL.

Can someone give me a technical explanation for how one would come to that conclusion? I’d love if you could pass technical documentation for that.

  • Geometrinen_Gepardi
    link
    fedilink
    arrow-up
    12
    ·
    7 days 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.

      • knightly the Sneptaur@pawb.social
        link
        fedilink
        arrow-up
        8
        ·
        edit-2
        7 days 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.pubOP
          link
          fedilink
          arrow-up
          2
          ·
          7 days 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.