Code:
create procedure yearly_income_tax_calculation_federal()
begin
declare salary float;
declare tax float;
SELECT salary_annually INTO salary FROM ndcga776_payroll_db.payroll WHERE payroll_id=2;
IF (salary>0 AND salary<=44701) THEN SET tax = salary*0.15;
ELSE IF (salary>44701 and salary<=89401) THEN SET tax=44701*0.15+(salary-44701)*0.22;
ELSE IF (salary>89401 and salary<=138586) THEN SET tax=44701*0.15+(89401-44701)*0.22+(salary-89401)*0.26;
END IF
END IF
ELSE SET tax=44701*0.15+(89401-44701)*0.22+(138596-89401)*0.26+(salary-138586)*0.29;
END IF
END
create procedure yearly_income_tax_calculation_federal()
begin
declare salary float;
declare tax float;
SELECT salary_annually INTO salary FROM ndcga776_payroll_db.payroll WHERE payroll_id=2;
IF (salary>0 AND salary<=44701) THEN SET tax = salary*0.15;
ELSE IF (salary>44701 and salary<=89401) THEN SET tax=44701*0.15+(salary-44701)*0.22;
ELSE IF (salary>89401 and salary<=138586) THEN SET tax=44701*0.15+(89401-44701)*0.22+(salary-89401)*0.26;
END IF
END IF
ELSE SET tax=44701*0.15+(89401-44701)*0.22+(138596-89401)*0.26+(salary-138586)*0.29;
END IF
END
Ova procedura mi ne radi u MySQL Workbench 6.2 64bit (Local Instance MySQL 5.6)