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