I am trying to create the following trigger:
CREATE TRIGGER update_customers AFTER INSERT ON wp_usermeta
FOR EACH ROW
BEGIN
if new.wp_metakey = first_name then insert into test_customer(first_name) values (new.wp_meta_value);
END
I keep getting a 1064 error that says, "You have an error in your SQL syntax; check the manual that corresopons to your MySQL server version for the right syntaxt to use near " at line 5"
What am I doing wrong?
Best Answer
The first problem is that you don't have an
END IF;
.The next problem (assuming that you aren't doing this and just didn't include it in the question) is that when you have a compound statement, you have to change the statement delimiter from
;
to something else so that the client will send the entireCREATE TRIGGER
statement to the server as a single statement.Finally, the column "first_name" probably needs to be qualified with
NEW
(assume you're referencing a column in wp_usermeta called "first_name".