MYSQL numerical alpha code

0

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?

    
asked by anonymous 29.11.2018 / 15:02

1 answer

1

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).

    
29.11.2018 / 15:59