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
