I want to code a MySQL DOMAIN in a random code, with 2 letters, 1 number, 1 letter, 2 numbers
AB-1A-21-DA-2B-35-CI-3U-23
How to proceed?
I want to code a MySQL DOMAIN in a random code, with 2 letters, 1 number, 1 letter, 2 numbers
AB-1A-21-DA-2B-35-CI-3U-23
How to proceed?
The default of AUTO INCREMENT in MySQL is always int! For your specific case, you will need to create a function with the criteria you mention above. The column for storing the result is varchar (8).