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>