syntax error for simple IF - THEN

[Jassm Rahma]

Hi,

I am trying to creat a simple IF - THEN in MySQL but getting a synax error message.

can anyone help please...

here is my statement:

IF EXISTS (SELECT payroll_id FROM payroll WHERE location_id = param_location AND payroll_month = param_month AND payroll_year = param_year) THEN
SET param_payroll_id = 0;
END IF;


Thanks,
Jassim