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