в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:50:56Z

1 версия

Новая страница

== 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>

← Предыдущая	Версия 13:44, 26 мая 2010
(нет различий)

MySQL Tutorial/Information Functions/VERSION - История изменений

в 13:44, 26 мая 2010

Admin: 1 версия