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`;