title: MySQL link tables - view, foreign keys or trigger?
body: <p>I apologize if <code>"link"</code> is not the exact term for this in advance. </p>
  
  <p>I have a table with user info, (user&amp;password). I need the same user:password pair to appear in another table in the same database. the second table needs to copy the first one at all times - if an entry is deleted from the first one, or added - the changes must apply to the second table instantly. </p>
  
  <p>Please, I need an example of how this can be done, as I do not know the terminology to search on google..</p>
  
  <hr>
  
  <p>I only need two columns to be a duplicate, not the entire table.</p>