MySQL Triggers using phpmyadmin

Question

I'm trying to write a very simple trigger for MySQL using phpmyadmin 4.0.8, what I want to do, is after a table called 'upload' is inserted into, I take the username, and id and put it into a second table called 'rating'

This is what I'm trying,

CREATE TRIGGER copy_pid AFTER INSERT on upload FOR EACH ROW BEGIN

INSERT INTO rating (uid,pid) VALUES (NEW.username,NEW.id);

END;

I get an "#1064 - You have an error in..."

user1864610 · Accepted Answer · 2013-11-14 02:47:48Z

1

MySQL is interpreting the semi-colon at the end of your INSERT statement as the end of the input. You need to change your delimiter while youe set up your trigger:

delimiter $$
CREATE TRIGGER copy_pid AFTER INSERT on upload FOR EACH ROW 

BEGIN

INSERT INTO rating (uid,pid) VALUES (NEW.username,NEW.id);

END$$
delimiter ;

answered Nov 14, 2013 at 2:47

user1864610

Sign up to request clarification or add additional context in comments.

4 Comments

Aage Torleif Over a year ago

That does fix it! But... now when I insert into upload nothing ends up in the table

Aage Torleif Over a year ago

This is what I'm doing now "DELIMITER // DROP TRIGGER IF EXISTS copy_pid // CREATE TRIGGER copy_pid AFTER INSERT on sc_main.upload FOR EACH ROW BEGIN INSERT INTO sc_main.rating (uid, pid) VALUES (NEW.username, NEW.id); END"

user1864610 Over a year ago

I didn't look at what your trigger was actually doing. Does your new code do what you need?

Aage Torleif Over a year ago

no, it just stops my from inserting into the table the this triggers on. But it did answer my syntax error I was wondering about

Collectives™ on Stack Overflow

MySQL Triggers using phpmyadmin

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related