mysql> delimiter $$ mysql> mysql> mysql> CREATE PROCEDURE myProc() -> BEGIN -> DECLARE a INT DEFAULT 2; -> DECLARE b INT DEFAULT 3; -> DECLARE c FLOAT; -> -> IF NOT (a=b) THEN -> SELECT 'a is not equal to b'; -> END IF; -> END$$ Query OK, 0 rows affected (0.00 sec)
mysql> mysql> delimiter ; mysql> call myProc(); +---------------------+ | a is not equal to b | +---------------------+ | a is not equal to b | +---------------------+ 1 row in set (0.02 sec)