MySQL Tutorial/Information Functions/VERSION

Check MySQL version in function

mysql>
mysql> delimiter $$
mysql>
mysql> CREATE PROCEDURE myProc()
    ->
    -> BEGIN
    ->   DECLARE major_version INT;
    ->
    ->   SET major_version=SUBSTR(version(),1,INSTR(version(),".")-1);
    ->   IF major_version>=5 THEN
    ->      SELECT "Good thing you are using version 5 or later";
    ->   ELSE
    ->      SELECT "This version of MySQL does not support stored procedures",
    ->             "you must be dreaming";
    ->   END IF;
    ->
    -> END$$
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> delimiter ;
mysql> call myProc();
+---------------------------------------------+
| Good thing you are using version 5 or later |
+---------------------------------------------+
| Good thing you are using version 5 or later |
+---------------------------------------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> drop procedure myProc;
Query OK, 0 rows affected (0.00 sec)
mysql>

VERSION() returns a string that indicates the MySQL server version.

mysql>
mysql> SELECT VERSION();
+---------------------+
| VERSION()           |
+---------------------+
| 5.0.41-community-nt |
+---------------------+
1 row in set (0.00 sec)
mysql>
mysql>