title: How to create an primary key in phpmyadmin?
body: <p>I have two tables, the first one is called BOOKSNAME and the second is called AUTHORNAME. </p>
  
  <p>I have made the ID column for the BOOKSNAME table as the primary key (BIGINT auto increment) then my AUTHORNAME table has NAME and ADDRESS as it's columns but I have no ID/Primary key on this. </p>
  
  <p>I want to make a relation between them by primary key, if anyone has an example of how this is achieved, could they share it?</p>