title: How do MySQL views work?
body: <p>When I create a view I am basically making a new table that will automatically be transacted upon when data in one of the tables it joins changes; is that correct?</p>
  
  <p>Also why can't I use subqueries in my view?</p>