At the time of entering the names and surnames (maternal and paternal) create an email with its first two letters. Example:
Armando Casas Sanchez = [email protected]
At the time of entering the names and surnames (maternal and paternal) create an email with its first two letters. Example:
Armando Casas Sanchez = [email protected]
You can update the email field by concatenating the values of the first and last names and the email domain.
update nombretabla set email = concat(substr(nombre,1,2),substr(paterno,1,2),substr(materno,1,2),"@ejemplo.pe")