IF region='Mumbai' OR region='Chennai' OR region='Bangalore' OR region='Pune' region='Coimbatore' OR region='Ahmedabad' THEN
SET region='South-west';
ELSE
SET region='North+East';
END IF;
I am trying to create a sp i have error in the above the Condition. rest of the Stored procedure is working fine when i remove the above if condition.
i am getting the error for multiple or condition in if statement.
please help.
Aucun commentaire:
Enregistrer un commentaire