Reply To: MySQL Joins

[chrisburton]

I wouldn’t have a users.uid. I would make users.id a unique key and then make comments.uid a foreign key referencing users.id.

@BenWalker A bit confusing. Are you saying I should do away with users.uid and just make the USER ID as users.id?

Right now, the user.id is just an auto incrementing column. I probably don’t need this now that I think about it because the users ID will be unique.