I need to update the value of a column that should equal to initial from name + last name + “@simuladores”
The name column is called nombre_jefe, the last name column is called apellido_jefe, and the column it should be added to is called email_empresa.
The problem is, everytime I try something and it goes through it just returns 0 in every row.
All the columns are type VARCHAR
It returns me:
| nombre_jefe | apellido_jefe | email_empresa |
|---|---|---|
| John | Gomez | 0 |
| Juan | Perez | 0 |
| Emily | Torres | 0 |
It should end up with something like this
| nombre_jefe | apellido_jefe | email_empresa |
|---|---|---|
| John | Gomez | jgomez@simuladores |
| Juan | Perez | jperez@simuladores |
| Emily | Torres | etorres@simuladores |
New contributor
Ariel Cholakian Saz is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.