title: update query inside view in mysql
body: <pre><code>mysql&gt; create view incremented_salary as
      -&gt; update employee set salary=salary*1.1;
  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  that corresponds to your MySQL server version for the right syntax to use near 
  'update employee set salary=salary*1.1' at line 2
  </code></pre>
  
  <p>can we put update query inside view? If yes then please tell me why I'm getting above error.I want to increment the salary and display it using view.</p>