CREATE DEFINER = 'root'@'%'
FUNCTION insertMegaRow(Param1 bigint UNSIGNED, Param2 int)
RETURNS INT
BEGIN
INSERT INTO table1 (column1) VALUE (Param1);
SET lastInsertId = SELECT LAST_INSERT_ID;
INSERT INTO table2 (column1, column2) VALUE(lastInsertId, Param2);
RETURN 1;
END

SELECT insertMegaRow (1, 2);

SELECT insertMegaRow (1, 2);

REATE DEFINER = 'root'@'%'
FUNCTION ecollege.addContingent(ayearID int UNSIGNED, departmentID tinyint UNSIGNED,
sofID int UNSIGNED, specialtyID bigint UNSIGNED, tot_id tinyint UNSIGNED, fileNumber int UNSIGNED,
dateOfReceipt date, firstName varchar(50), lastName varchar(50), Patronomic varchar(50), institutionID bigint UNSIGNED,
yearOfGrad year, awardID int UNSIGNED, orphan tinyint UNSIGNED, disabilityID tinyint UNSIGNED, cityPhone1 varchar(50), mobilePhone1 varchar(50), village tinyint UNSIGNED,
hostel tinyint UNSIGNED, exameDate date, totalPoints tinyint UNSIGNED, profPoints tinyint UNSIGNED,
Agreement tinyint UNSIGNED)
RETURNS int(11)
BEGIN
INSERT INTO contingent (file_number, date_of_receipt, first_name, last_name, patronomic,
year_of_grad, orphan, village, hostel, exame_date, total_points, prof_points, agreement) VALUES (
fileNumber, dateOfReceipt, firstName, lastName, Patronomic, yearOfGrad, orphan, village, hostel,
exameDate, totalPoints, profPoints, Agreement);
set @id = LAST_INSERT_ID();
INSERT INTO main_contingent_options_relationship (contingent_id, ayear_id, department_id, sof_id,
specialty_id, tot_id) VALUES
(@id, ayearID, departmentID, sofID, specialtyID, tot_id);

INSERT INTO `contingent-institution_relationship` (contingent_id, institution_id) VALUES (@id, institutionID);
INSERT INTO `contingent-award_relationship` (contingent_id, award_id) VALUES (@id, awardID);
INSERT INTO `contingent-disability_relationship` (contingent_id, disability_id) VALUES (@id, disabilityID);
INSERT INTO `contingent-address_relationship` (contingent_id, address_id) VALUES ($id, addressID);
RETURN 1;
END