two-digit autoincrementable column

1

I have A tabla turns with a shift column that this car can be increased but I would like to place it with two digits. example:
01
02
03
...
09
10
Any idea how to get there?

    
asked by steven 24.07.2018 в 18:28
source

1 answer

3

This way it could be:

 create table TURNOS ( 
 turno int(2) zerofill not null auto_increment,
 primary key(turno) );
    
answered by 24.07.2018 в 18:37