Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELIMITER $$
- CREATE procedure checkMonthTax(IN studId INT, IN groupId INT, IN paymentMonth INT, IN paymentYear INT)
- BEGIN
- DECLARE result char(1);
- SET result = 0;
- IF( (SELECT paymentAmount
- FROM taxespayment
- WHERE student_id = studId
- AND group_id = groupId
- AND month = paymentMonth
- AND year = paymentYear) IS NOT NULL)
- THEN
- SET result = 1;
- ELSE
- SET result = 0;
- END IF;
- SELECT result AS IsTaxPayed;
- END$$;
- DELIMITER ;
- CALL checkMonthTax(1,1,1,2022);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement