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 ';' 
> 
> 
>

Answer: 
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.
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](http://sqlfiddle.com/#!2/d1ee1/1)`