Is it possible to have an auto-increase text field?

[alex298]

Hello,

Is it possible to make an auto-increase text field, for example 0001, 0002, 0003, ..............?

Thanks and best regards

[guelphdad]

No, it wouldn't do that. What are you using the field for? Normally an auto increment field is used because there is no other suitable candidate for a primary key in your data. You should not rely on your auto increment column for any specific sequence of numbers as they get added and deleted, they will eventually have missing numbers in the sequence.