vendredi 1 avril 2016

Multiple condition in if....else inside stored procedure

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