Auto reset of auto-incrementing field after delete of any field

koolninja · June 20, 2018, 4:39am

is there any way to auto-incrementing field get auto reset after delete of any field

suggestion expected

thanks

Xoristzatziki1 · June 20, 2018, 4:53am

Are you looking for a general solution independent from database used (Mysql, internal HSQLDB etc.) or you are working with a spceific DB? The approach will be different. Specific solution may work faster.

koolninja · June 20, 2018, 9:45am

FOR HSQLDB 2.0v

Xoristzatziki1 · June 22, 2018, 5:34am

Try this. Search for restart. The best is to create a trigger that will restart counter after a delete is made.