To determine the version of MySQL running on your DB system, you can use the following SQL statements:
SELECT @@version;(Answer B): This query retrieves the MySQL server version from the system variables.
SHOW VARIABLES LIKE 'version';(Answer C): This query displays the server version along with other related version variables.
Steps:
Connect to your MySQL DB system.
Execute eitherSELECT @@version;orSHOW VARIABLES LIKE 'version';to retrieve the version information.
References:
MySQL Server Version Information
SHOW VARIABLES Syntax
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit