SQLyog has been specially designed to work on remote connections. It is very efficient on network bandwidth giving you the best possible environment to work with MySQL server on remote connections.
I want to give a user privileges only to particular columns in a table ? Can I do it in SQLyog.
Yes! By using SQLyog's powerful and easy to use Manage Permissions tool, you can give database, table & column level privileges to any user. The Manage Permissions option can be found at Tools -> User Manager -> Manage Permissions
SQLyog allows you keep your frequently used SQL scripts in a Personal Folder. To save a SQL query press Ctrl+Shift+F and provide a name. When you want it back, press Ctrl+Shift+P and select the query name from the popup menu. SQLyog allows you to have 99 SQL queries in the personal folder.
SQLyog allows you keep your frequently used SQL scripts in a Personal Folder. To save a SQL query press Ctrl+Shift+F and provide a name. When you want it back, press Ctrl+Shift+P and select the query name from the popup menu. SQLyog allows you to have 99 SQL queries in the personal folder.