How to create a MySQL generated column that uses a join in a concat?
I have a column that is a concatenation of 5 other columns plus a join to a different table.
UPDATE db.a JOIN db.b ON fk_b = b.pk SET concat_field = CONCAT(field1,field2,field3,b.field,field4,field5)
What I would like to do is set the
concat_field to a generated column,
concat_field VARCHAR(255) GENERATED ALWAYS AS (CONCAT(fields)) stored,
However while it's easy to do with a straight
concat the join is giving me trouble.
How would I turn the update statement into a generated field?