How to retrieve the current version of a MySQL database management system (DBMS)?

by

Try this function –

SELECT VERSION();
-> '5.7.22-standard'

VERSION()

Or for more details use :

SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------------------+
| Variable_name           | Value                                    |
+-------------------------+------------------------------------------+
| protocol_version        | 10                                       |
| version                 | 5.0.27-standard                          |
| version_comment         | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686                                     |
| version_compile_os      | pc-linux-gnu                             |
+-------------------------+------------------------------------------+
5 rows in set (0.04 sec)

MySQL 5.0 Reference Manual (pdf) – Determining Your Current MySQL Version – page 42

More Related Contents:

  1. Why do I get an error from this sub query script?
  2. sql query to modify the selected value from database [closed]
  3. how to get similar search results in MySQL?
  4. Can I concatenate multiple MySQL rows into one field?
  5. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  6. How to do the Recursive SELECT query in MySQL?
  7. MySQL, update multiple tables with one query
  8. Do different databases use different name quote?
  9. MySQL case sensitive query [duplicate]
  10. Simulating MySQL’s ORDER BY FIELD() in Postgresql
  11. What does mysql error 1025 (HY000): Error on rename of ‘./foo’ (errorno: 150) mean?
  12. How do I change the data type for a column in MySQL?
  13. mysql fulltext search failure
  14. Adding a leading zero to some values in column in MySQL
  15. Using SQL to determine word count stats of a text field
  16. Update one MySQL table with values from another
  17. MySQL Order before Group by
  18. How to transpose mysql table rows into columns
  19. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  20. Replace Into Query Syntax
  21. adding RMySQL package to R fails (on Windows)?
  22. Ruby gem mysql2 install failing [duplicate]
  23. What’s the best way to migrate a Django DB from SQLite to MySQL?
  24. find number of rows in returned mysql result (nodejs)
  25. What is difference between storing data in a blob, vs. storing a pointer to a file?
  26. mysql select distinct rows into a comma delimited list column
  27. How do I limit the number of rows per field value in SQL?
  28. Are Users ‘User’@’%’ and ‘User’@’localhost’ not the same?
  29. MySql – Update table using select statment from same table
  30. How to allow fulltext searching with hyphens in the search query

Leave a Comment