Updating column in same table after insert...

[Jim Reamer]

I'm extremely new to using triggers. I'm trying to streamline data entry process for my db users, me included. It will also help eliminate typos.

I'd like a column (name) to reflect entry from two other columns (nameFirst and nameLast). I'm trying to do so via this trigger:

Action Time: After
Event: Insert

update a_players
set NEW.wpSlug = concat(lower(NEW.nameFirst),'-',lower(NEW.nameLast))


I'm getting this error:

Can't update table 'a_players' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.



I keep looking up different syntaxes, and I can't wrap my head around how it should work.

Thank you.