Re: Setting a row's value to the primary key after insert

[Carl Dunham]

Try this:

delimiter //

CREATE TRIGGER calendar_insert_after AFTER INSERT
ON calendar
FOR EACH ROW
BEGIN
IF NEW.group_id IS NULL THEN
SET NEW.group_id = NEW.calendar_id;
END IF
END; //
delimiter ;