Mega Code Archive

 
Categories / MySQL / Command Mysql
 

Determine which functions the running version of MySQL supports with the SQL command SHOW VARIABLES

mysql> mysql> SHOW VARIABLES LIKE 'have%'; +-------------------------+----------+ | Variable_name           | Value    | +-------------------------+----------+ | have_community_features | YES      | | have_compress           | YES      | | have_crypt              | NO       | | have_csv                | YES      | | have_dynamic_loading    | YES      | | have_geometry           | YES      | | have_innodb             | YES      | | have_ndbcluster         | NO       | | have_openssl            | DISABLED | | have_partitioning       | YES      | | have_query_cache        | YES      | | have_rtree_keys         | YES      | | have_ssl                | DISABLED | | have_symlink            | YES      | +-------------------------+----------+ 14 rows in set (0.00 sec) mysql>