I've found numerous ideas on how to do this. Here is my current query:
Action: After Event: Insert (a_players)* insert wp_termsset name = concat(NEW.nameFirst,' ',NEW.nameLast), slug = concat(NEW.nameFirst,'-',NEW.nameLast)
* a_players is the table and not showing the in trigger window.
I've tried to do it as a Before, but I already have a Before trigger, and for some reason I can't have two Befores.
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.
However, it does insert the new row into wp_terms. The problem is I'm getting that error, prompting me cancel and it's inputting the row twice.