Add automtically to a group when customer signs

[apeksha]

I wrote this trigger to automatically add Customer to a new group when he/she signs in to my site.

 

 

CREATE OR REPLACE TRIGGER add_to_group

AFTER insert ON ps_customer

FOR EACH ROW

BEGIN

insert into ps_customer_group values(new.id_customer,2);

END

 

But this wont work, Showing sql error.

Please help