Hi,I want to generate unique ID in the database that has the combination of characters and digits.
eg. ab111 and next should be ab112 ,ab113 and so on.
Can anybody help me?
sumangala 0
Newbie Poster
samaru 145
a.k.a inscissor Team Colleague
Hi,I want to generate unique ID in the database that has the combination of characters and digits.
eg. ab111 and next should be ab112 ,ab113 and so on.
Can anybody help me?
What is the max number of characters and how do they increment?
What's after ab999? Is it ab1000? Or ac000? What happens when it reaches zzz999? You can use a composite key for this.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.