Password generator from firstname with 4 latter and dob with month and day and lowercase.

Tiger Analytics

Input:

firstname    dob

Shahrukh    1980-01-20

Salman        1982-02-10

Output:

firstname    dob                    passgen

Shahrukh    1980-01-20        shah2001

Salman        1982-02-10        salm1002        

Soluton:

select *, lower(concat(substring(firstname,1,4),Date_format(dob,"%d%m")))as passgen from passtable;