Colin Hill writes:
> 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
>
Try:
SELECT VERSION();
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
