delimiter //
create procedure proc()
Begin
declare col int;
declare y int;
declare x int;
declare year1 int;
select count(*) from table3 into x;
set y=0;
Asd: while i<=a DO
set y=y+1;
select MONTH (birthday) from table3 into year1;
if ((year1='0')or(year1='2')) then Update table3 set vremya_goda = 'zima' ;
if ((year1='3')or(year1='5'))then update table3  set vremya_goda='vesna';
if ((year1='6')or(year1='8'))then update table3  set vremya_goda='leto';
if ((year1='9')or(year1='11'))then update table3 set vremya_goda='osenb';
update table3 set performance=year1 where n_ticket=y;
if y<=x then iterate asd;
else leave asd;
end if;
end loop;
select * from table3;
end//