Get next AUTO INC value for a tables auto inc column

  //Will get the next (not last) auto inc value from the table named MyTableName (you don't specify the column name)
  $sql = "SELECT AUTO_INCREMENT as NextAutoIncValue FROM INFORMATION_SCHEMA.TABLES WHERE table_name = 'MyTableName' and table_schema = database() ";
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.


Your email address will not be published. Required fields are marked *