DROP PROCEDURE IF EXISTS `procedure_foo`;
DELIMITER $$
CREATE PROCEDURE `procedure_foo`()
BEGIN
DECLARE id int default 0;
INSERT INTO cms_form_completed_advocacy_letter (created_at) VALUES (NOW());
SET id = last_insert_id();
IF id <> 0 THEN
INSERT INTO cms_form_completed_advocacy_letter_recipients (form_completed_advocacy_letter_id, hash_id, user_contact_id) VALUES (id, id, 4);
END IF;
END
$$
DELIMITER ;
CALL procedure_foo();
DROP PROCEDURE IF EXISTS `procedure_foo`;