title: Delete query not working in mysql
body: <p>I am trying to delete all records from a table called user_enrole.I am using this query</p>
  
  <pre><code>DELETE * FROM user_enrole
  </code></pre>
  
  <p>I think syntax of my query is not wrong but it is giving me error saying </p>
  
  <blockquote>
    <p>#1064 - 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 '* FROM user_enrole' at line 1</p>
  </blockquote>
  
  <p>I have doubled check my syntax i am not able to figure out what is going wrong can someone point out please.</p>
  
  <p>Is it occuring because of the relationship this table has with use table or what?</p>