Virtual column email

Question

How do I get a proper field builded with the data of all names columns + the @sales.es?

The following just set all to 0.

ALTER TABLE comercial ADD COLUMN email VARCHAR(100) GENERATED ALWAYS AS 
    (nombre+'.'+ surname1 + surname2 +'@sales.es') VIRTUAL AFTER province;

Are any of those values `NULL`? SQL requires _all_ values to be non-`NULL` for concatenation to succeed, so you may need need to wrap everything in `COALESCE`. — Dai, Mar 16 '22 at 22:10
What if you use explicit `CONCAT( nombre, '., surname1, surname2, '@sales.es' )` instead of `+` ? — Dai, Mar 16 '22 at 22:15
Done, It works if I surround the concat like: ( CONCAT ( )), thank you. — Jose Navío, Mar 16 '22 at 22:26

score 1 · Answer 1 · answered Mar 16 '22 at 23:48

1

MariaDB uses CONCAT for string concatenation, not +.

So change your statement to this:

ALTER TABLE comercial
    ADD COLUMN email VARCHAR(100) GENERATED ALWAYS AS ( CONCAT( nombre, '.,  surname1, surname2, '@sales.es' ) ) VIRTUAL AFTER province;

answered Mar 16 '22 at 23:48

Dai

141,631
28
261
374

Virtual column email

1 Answers1