FviFAWf2

11/ suzdaite triger koito da validira duljinata na imeto i na nomera na studenta 
22/ttablica za info na smetki na studentite, sled tova procedura vseki mesec drupa pari od smetkata i plashta i gi prehvrla v tablica
3s taxite na studentite
4
5use school_sport_clubs;
6
7drop procedure if exists thirdWork;
8
9delimiter |
10create procedure thirdWork(IN monthOfPayment INT, in yearOFpayment INT)
11procLabel: begin
12declare countOfStudents int;
13declare iterator int;
14declare countOfRowsBeforeUpdate int;
15declare countOfRowsAfterUpdate int;
16declare finished int;
17declare tempCoachId int;
18declare tempSumOfHours int;
19
20 DECLARE tempTaxesPaymentCursor CURSOR FOR
21    SELECT  student_id, SUM(paymentAmount)
22	FROM taxespayments
23	WHERE student_id = students.id
24	GROUP BY coach_work.coach_id;
25    
26DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'SQL Exception';
27DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished = 1;
28SET finished = 0;
29create temporary table tempTbl(
30id int auto_increment primary key,
31student_id int,
32group_id int,
33pay_for_hour decimal,
34amount decimal,
35paymentMonth int,
36paymentYear int
37)Engine = Memory;