Syntax error if statement mySQL

Question

create trigger tr_af after update on relatorio_notas 
for each row
if (new.Nota < 7) then
insert into aluno_af (nome, matricula) values (new.Nota, new.Matricula_estudante)
end if;

I got syntax error and I don't know why

Community · Accepted Answer · 2017-05-23 12:05:47Z

1

You need a BEGIN and END block in your syntax. See the 13.1.11 CREATE TRIGGER Syntax:

create trigger tr_af after update on relatorio_notas
for each row
begin               # <-------------------
  if (new.Nota < 7) then
  insert into aluno_af (nome, matricula) values (new.Nota, new.Matricula_estudante);
  end if;
end                 # <-------------------

Note you may need to set the delimiter to something different than ;.

See more info in MySQL syntax check or a sample in Trigger syntax and IF ELSE THEN.

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Nov 27, 2014 at 23:53

fedorqui

293k113 gold badges592 silver badges640 bronze badges

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

Collectives™ on Stack Overflow

Syntax error if statement mySQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related