Digital Journal » MySQL version https://digitaljournal.sg/wp My Digital Journal Mon, 20 Oct 2014 00:32:27 +0000 en-US hourly 1 http://wordpress.org/?v=3.4.2 Find out MySQL and MsSQL on Windows https://digitaljournal.sg/wp/?p=121 https://digitaljournal.sg/wp/?p=121#comments Thu, 25 Oct 2012 09:38:59 +0000 admin http://digitaljournal.sg/wp/?p=121 This might be helpful in case you are maintaining Windows server and need to find out whether your MsSQL and MySQL is applicable for patches or fixes from vendors, because sometimes Windows not displaying the exact version until application minor number.

To check Microsoft SQL/mssql version:
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY
(‘productlevel’), SERVERPROPERTY (‘edition’)

To check mysqld server:
SHOW VARIABLES LIKE “%version%”;

]]> https://digitaljournal.sg/wp/?feed=rss2&p=121 0