title: mysql create table based on columns from another table and auto updated
body: <p>I could have the wording 'wrong' here (new to mysql) but i hope i've explained what I'm trying to do well.</p>
  <p>i have a table called submissions with 4 fields submitId, studentName, submitDate, status</p>
  <blockquote>
  <ul>
  <li><p>status refers to whether they got admitted or not.</p>
  </li>
  <li><p>submitId is auto incremented</p>
  </li>
  </ul>
  </blockquote>
  <p>Now i wanted to create another table based on that, but only if the status is true, this new table would have the submitId, studentName, submitDate, plus additional fields.</p>
  <blockquote>
  <ul>
  <li>this table would have a new auto increment studentId</li>
  </ul>
  </blockquote>
  <p>how would i do that so it automatically updates any new entry to the first table on the second table, but not overwrite the additional content of table 2.</p>
  <p>i thought of using a view, but u can't add new columns on the view, right?
  do i have the logic wrong here or what are the options, could someone please point me in the right direction, thanks</p>