Insert into trigger

Question

i got a problem here , in MYSQL i have:

1-Table called "norte" it has a column called "nortel" 2-Table called "bitacora" it has a column called "telefono"

im making a trigger for copying this information for example whenever i add something to "norte" table i want it to be automatically copied to bitacora table, i dunno what im doing wrong here´s my trigger

CREATE TRIGGER insertar AFTER INSERT ON norte
FOR EACH ROW 
BEGIN
INSERT INTO bitacora SET telefono = NEW.nortel 
END;

the problem here is that it says unexpected END expecting';'

but if i delete the "END" it says

CREATE TRIGGER insertar AFTER INSERT ON norte
FOR EACH ROW 
BEGIN
INSERT INTO bitacora SET telefono = NEW.nortel;

Unexpected END_OF_INPUT expecting ';'

juergen d · Accepted Answer · 2013-10-24 18:21:58Z

1

You need to change the delimiter.

delimiter |
CREATE TRIGGER insertar AFTER INSERT ON norte
FOR EACH ROW 
BEGIN
    INSERT INTO bitacora (telefono) values (NEW.nortel);
END
|
delimiter ;

Otherwise the DB thinks your trigger statement ends at the first ; and then it would be incomplete.

edited Oct 24, 2013 at 18:21

answered Oct 24, 2013 at 18:12

juergen d

205k40 gold badges304 silver badges377 bronze badges

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

Comments

Filipe Silva · Accepted Answer · 2013-10-24 18:08:56Z

0

You are missing a " ; " after the NEW.nortel:

It should be:

CREATE TRIGGER insertar AFTER INSERT ON norte 
FOR EACH ROW 
BEGIN 
  INSERT INTO bitacora SET telefono = NEW.nortel; 
END;

sqlfiddle demo

answered Oct 24, 2013 at 18:08

Filipe Silva

21.7k6 gold badges56 silver badges70 bronze badges

1 Comment

Cesar Cisneros Over a year ago

Thx for your; help i used the first answer and it seems it worked anyways thx both for responding me :) HAVE A GREAT DAY

slfan · Accepted Answer · 2018-10-29 18:49:36Z

0

DELIMITER $$


CREATE TRIGGER row_update_trigger  AFTER INSERT ON returns_loading_dc 
  FOR EACH ROW BEGIN
    INSERT INTO   Returns_receiving_Fc 
    set 
      Var_key=NEW.Var_key,
      Product_Title=NEW.Product_Title,
      Building=NEW.Building,
      Hub_ID=NEW.hub_id,
      JPIN=NEW.JPIN,
      Tagging_Required=NEW.Tagging_Required,
      Food_Non_Food=NEW.Food_Non_Food,
      Qty_loaded_from_hub=NEW.Total_Quantity_Loaded;


END $$ need help

edited Oct 29, 2018 at 18:49

slfan

9,129115 gold badges69 silver badges81 bronze badges

answered Oct 29, 2018 at 18:24

Manohar U

1

Collectives™ on Stack Overflow

Insert into trigger

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related