How do I go about querying a mySQL server for version information? As part of a software installer (written in Perl) I'd like ot be able to connect to the mySQL server designated by the user and have it report it's version. Is there a way to do this?
So far I've been relying on the version information relating to the mySQL client, however it's unreasonable to expect that the mySQL client software will exist (although the libraries will be there) on the machine where my software will be installed. So, is there a way to retrieve the version information directly from the server using some pseudo SQL query? This all relates to attempting to determine whether the installed version of the server will support FULLTEXT indexes (version 3.23.23+) so if there's an easier way to make that determination, like perhaps parsing a special error code (other than just 'bad SQL'), I guess that'd work too, but I'm not sure what that error code might be since I don't have the extra hardware available to install an earlier version of mySQL for testing. Regards, Colin Hill --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
