Use Tools -> Flush… (Ctrl+Shift+F) option if you want to clear some of the internal caches MySQL uses. To execute FLUSH statements, you must have the RELOAD privilege. The following table illustrates…
Variables Select Tools -> Show -> Variables. To Show global variables and their current values. Processes Show all current running processes and their current status. You can use this option to…
You can set preferences for SQLyog environment using Tools -> Preferences. Five tabs are available in the dialog: Generate queries using backquotes: Checking this option will enclose table and column names in…