Jim R Posted September 5, 2017 Share Posted September 5, 2017 Action Time: After Event: Insert update a_players set NEW.name = 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. My Trigger first didn't have NEW in them. I've looked that up, found usage of NEW, but even that still produced the error above. Is it possible to Update a column of a row in real time as/after Inserting that new row? I'm trying to streamline data entry for my writers. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.