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