3 comments
Comment from: Andrew [Visitor]
Andrew

Hi,

For all versions of mysql if you do SHOW VARIABLES; you will see the version in the list returned regardless of the version of mysql used.

10/11/07 @ 10:37
Comment from: ryan [Visitor]
ryan

SELECT VERSION(); will work on mysql 3.23

05/11/10 @ 00:20
Comment from: shahryar ghazi [Visitor]
shahryar ghazi

here is a complete tutorial http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_check_mysql_version_number.php

i guess u r only printing the client’s version no. thru mysql -v

11/02/10 @ 14:43