devxlogo

January 12, 2018

Knowing the Version and Supported Engines in MySQL

The following commands are handy to know the current version and the supported engines in the MySQL. Command: SELECT VERSION()Output: 5.6.31-enterprise-commercial-advanced-logCommand: SHOW ENGINESOutput: InnoDBCSVMyISAMBLACKHOLEMEMORYFEDERATEDARCHIVEMRG_MYISAMPERFORMANCE_SCHEMA