create trigger insert_trigger
before insert on table
for each row
set new.username = concat(new.firstname, new.lastname, new.DOB);

create trigger update_trigger
before update on table
for each row
set new.username = concat(new.firstname, new.lastname, new.DOB);