mysql - Adding a leading zero to some values in column -

i have csv file sent me in csv. field of interest 8 digits. of started 0. field sent numeric. so, have dropped leading zeros.

i converted field varchar. need this:

i have now:

12345678
1234567

i need have this:

12345678
01234567

i using mysql.

thanks

change field numeric , use zerofill keep zeros

or

use lpad()

select lpad('1234567', 8, '0');