MySQL Tutorial/Information Functions/VERSION

Check MySQL version in function

   <source lang="sql">

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></source>

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

   <source lang="sql">

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