MySQL Forums
Forum List  »  Triggers

Using Sequel Pro and keep getting syntax errors for my trigger...
Posted by: Jim Reamer
Date: December 19, 2017 08:25AM

MySQL version is 5.5.51-38.2
I'm using Sequal Pro to access and edit my database.

I want to insert rows into wp_terms as I manually insert rows into a_players. I'm trying to set this trigger up in a_players...

Action time: After
Event: Insert

Insert into `wp_terms`
set `name` = concat(NEW.nameFirst .' '. NEW.nameLast);

I get syntax errors. I've tried it without the back ticks as well.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.