January 12, 2018

Knowing the Version and Supported Engines in MySQL

January 12, 2018

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

Quickly preview the file in windows explorer with a keyboard shortcut

January 12, 2018

Press Alt and P keys together to get a quick preview of the file in windows explorer. A preview is shown on the right pane. There is no need to change the view or install any third-party plugins for this.