delimiter //

CREATE PROCEDURE test_if_pro(in sal DOUBLE)

BEGIN

  if sal < 3000

    then delete from employees where salary = sal;

elseif sal <=5000

     then UPDATE employees set salary=salary + 1000 where salary = sal;

else 

  update employees set salary = salary + 500 where salary = sal;

END if;

END //

delimiter ;

delimiter ;

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delimiter' at line 1