I'm trying to divide all the EXISTING Entry Nos by 10 as it reached the maximum limit(The range for 32bits is 2,147,483,648).
So by dividing all the existing Entry No. and by changing the incrementation from 10,000 to 1000, I would extend how many more lines I can add, which is about 10x.
My question is how can I divide the Existing Entry Nos and should I add the code in the table or somewhere else?
Thank you in advance.