title: Remove AUTO_INCREMENT from a table? (not from a particular row)
body: <p>Making an sql database </p>
  
  <pre><code>U_MAIL
  U_PNUMBER
  U_ID (PK)
  U_ADDRESS
  U_PASSWORD
  </code></pre>
  
  <p>Accidentally whilst doing this i managed to set the whole table to auto increment rather than just the field <code>U_ID</code>. Is there any way of deleting this so i can then set <code>U_ID</code> to auto increment? I have googled but can't find anything related to deleting it from table, just from  a particular field</p>