CODEWITHSUNDEEP
mysqltriggerscentos
Chella
Chella

Reputation: 1562

Syntax error when creating the trigger

I am getting syntax error in creating the following trigger:

create trigger x.generate_responsibility 
before insert on x.organization_applications_b 
for each row 
begin

    call x.resp_auto_generate(new.org_id,new.application_code);

end;

Upvotes: 1

Views: 82

Answers (1)

Bohemian
Bohemian

Reputation: 425073

Precede this command with:

delimiter //

and follow with

delimiter ;

so you can use the semi-colon as part of your trigger source while defining your trigger, then make the semi colon the usual command delimiter after you're done.


The whole thing should look like this:

delimiter //
create trigger x.generate_responsibility 
before insert on x.organization_applications_b 
for each row 
begin
    call x.resp_auto_generate(new.org_id,new.application_code);
end; //
delimiter ;

Upvotes: 2

Related Questions