How to get the next auto-increment value

How to get the next auto-increment value

Do  this simple things  first create a table record : For example: create table  batch (id  int primary key atuo_increment,  name   varchar(...