First of all, thanks for reading.
I am adding data from php to a bd and I have a field in my table that has to be generated consecutively, but when I delete some fields and add a new one, the consecutive numbering stays in the last field that I delete, know if there is way to fix it (I'm using Navicat as a manager).
And how could I do that in addition to the first consecutive field I also generate the second one that is "PROY000016", since that one is like varchar.
I leave an image to give you an idea:
I would really appreciate your help.