Menu
Community /Pin to ProfileBookmark
@NogDogNov 02.2012 — #The best answer probably depends on what you mean by an alphanumeric ID. Does the alpha part increment in some way, and if so, what are the rules for that? If the alpha part is static, then you don't even need it in the DB: just prepend it to the numeric ID when you output it (perhaps using [s]printf() or similar functions to prepend zeroes so that it's a fixed length?). Without know the full requirement, though, we're all just speculating (or least I am).@NogDogNov 05.2012 — #
In that case I would go with my suggestion of just using an auto-increment integer column, then prepend the "ASP" part when actually outputting it to the user:
How to generate alphanumeric auto increment id in mysql?
How to generate alphanumeric auto increment id in mysql?
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogNov 02.2012 — #The best answer probably depends on what you mean by an alphanumeric ID. Does the alpha part increment in some way, and if so, what are the rules for that? If the alpha part is static, then you don't even need it in the DB: just prepend it to the numeric ID when you output it (perhaps using [s]printf() or similar functions to prepend zeroes so that it's a fixed length?). Without know the full requirement, though, we're all just speculating (or least I am).0
@NogDogNov 05.2012 — #I have to generate id like this ASP01,ASP02......[/QUOTE]
In that case I would go with my suggestion of just using an auto-increment integer column, then prepend the "ASP" part when actually outputting it to the user:
[code=php]
printf('ASP%02d', $integerValueFromDatabase);
[/code]