and more in a single search tool across platforms. Read the announcement here. |
03/27/2024 11:35 AM
Hi All,
We want to generate a sequence as below:
ABY8
ABY9
ABZ1
ABZ2
ABZ3
ABZ4
ABZ5
ABZ6
ABZ7
ABZ8
ABZ9
ACA1
ACA2
We have tried using systemusername generation rule for this. The autoincrement is for numbers and not for alphabet.
Is there any way we can generate this sequence?
Thanks,
Bhushan
03/27/2024 11:54 AM
As per my understanding this doesnt seem to be feasible.
03/27/2024 12:04 PM
MySQL doesn't directly support incrementing alphabets in a sequence. You would typically handle this in application logic rather than relying solely on SQL.