title: Max of a coll in my sql
body: <p>I want to make a register system, to record some values from html inputs in a Database, I use the following query:<code>INSERT INTO Search (id, username, fname, lname, age, fullname) VALUES ('?', '$username', '$fname', '$lname', '$age', '$fullname');</code>
  <p>
  But I don't know how to increment the id every time when submit a name:
  <br>
  <a href="https://i.stack.imgur.com/3k1oS.png" rel="nofollow noreferrer">see here</a>
  I want something like:<p>
  id<br>
  """"""""""""""""<br>
  1<br>
  max+1<br>
  new max+1</p>