Run SQL TRIGGER

[alirezaok]

hi

I want to run this SQL:

CREATE TRIGGER customer_call AFTER INSERT ON cdr

FOR EACH ROW Begin
    INSERT INTO smscalls (`id`,`from`,`to`,`state`,`sent`) VALUES (0,'1','1','1','0');

END;

but it gives me this error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

Note: only INSERT line works successfully Solely

[traq]

You need to change your delimiter when you define the trigger. Otherwise, MySQL thinks the ; at the end of your statement is the end of your trigger.

DELIMITER ~~

CREATE TRIGGER customer_call AFTER INSERT ON cdr FOR EACH ROW
    BEGIN
        INSERT INTO smscalls (`id`,`from`,`to`,`state`,`sent`) VALUES (0,'1','1','1','0');
    END~~

DELIMITER ;

Also, is there a reason you're inserting the exact same record each time? (Unless there's an auto_increment primary key -that is NOT listed here- then only the first insert will succeed.) And why insert the id as a number, but the other cols as numeric strings?