title: difference in simple insert query and inserting through a view into a table
body: <p>i am studying about views in sql and somewhat confused and having the following query : </p>
  
  <p>i have a table 'item' and need to insert data into it. am using two ways, one without view and the other using a view.</p>
  
  <pre><code>CREATE VIEW vw_item
  SELECT * FROM item
  </code></pre>
  
  <ol>
  <li><p>Inserting via the view:</p>
  
  <pre><code>INSERT INTO vw_item values(...)
  </code></pre></li>
  <li><p>Inserting via the table:</p>
  
  <pre><code>INSERT INTO item values(...)
  </code></pre></li>
  </ol>
  
  <p>What's the difference in query 1 and 2? That is, directly inserting into the table &amp; using a view to insert into the table.</p>
  
  <p>Is there a difference in insertion only when we use <code>CHECK OPTION</code> while creating the view?</p>