mysql>
mysql> delimiter $$
mysql>
mysql>
mysql> CREATE PROCEDURE myProc()
-> BEGIN
->
-> IF (CAST(SUBSTR(version(),1,3) AS DECIMAL(2,1)) <5.0) THEN
-> SELECT 'MySQL versions earlier than 5.0';
-> ELSE
-> SELECT 'Thank you are running 5.0 or higher!';
-> END IF;
->
-> END$$
Query OK, 0 rows affected (0.02 sec)
mysql>
mysql> delimiter ;
mysql> call myProc();
+--------------------------------------+
| Thank you are running 5.0 or higher! |
+--------------------------------------+
| Thank you are running 5.0 or higher! |
+--------------------------------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> drop procedure myProc;
Query OK, 0 rows affected (0.00 sec)
mysql>