title: Finding the next available id in MySQL
body: <p>I have to find the next available id (if there are 5 data in database, I have to get the next available insert place which is 6) in a MySQL database.  How can I do that?
  I have used <code>MAX(id)</code>, but when I delete some rows from the database, it still holds the old max value it didn't update.</p>