How to check the MySql version

Posted on Posted in MySql, Programming, Uncategorized

Create a query with: SHOW VARIABLES LIKE “%version%”; Result is similar to: Variable_name            Value                          ———————–  —————————— innodb_version           5.6.35                         protocol_version         10                             slave_type_conversions                                  version                  5.6.35-log                     version_comment          MySQL Community Server (GPL)   version_compile_machine  x86_64                         version_compile_os       Win64