This tutorial which help you to generating auto no using java and mysql. Establish the database Connection [crayon-6473c33778816275833266/] Auto no generator.create the function Custno(). [crayon-6473c3377881c119557692/] Add Records. after add the record Customer no will be incremented by 1 [crayon-6473c3377881e910001136/] I have attached the video tutorial below it will help you  to do this  step by step.