Comment on How does this pic show that Elon Musk doesnt know SQL?
DarthKaren@lemmy.world 5 days agoJFC: married individuals, or divorced and name change back, would be totally fucked. Just on the very surface is his fuckery.
Comment on How does this pic show that Elon Musk doesnt know SQL?
DarthKaren@lemmy.world 5 days agoJFC: married individuals, or divorced and name change back, would be totally fucked. Just on the very surface is his fuckery.
GoodEye8@lemm.ee 5 days ago
Hypothetically you could have a separate “previous names” table where you keep the previous names and on the main table you only keep the current name. There are a lot of ways to design a db to not unnecessarily duplicate SSNs, but without knowing the implementation it’s hard to say how wrong Musk is. But it’s obvious he doesn’t know what he’s talking about because we know that due to human error SSN-s are not unique and you can’t enforce uniqueness on SSN-s without completely fucking up the system. Complaining about it the way he did indicates that he doesn’t really understand why things are the way they are.