Home › Forums › Back End › MySQL Joins › Reply To: MySQL Joins
May 6, 2014 at 5:30 pm
#169373
chrisburton
Participant
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.