SQLyog MySQL GUI – Most Powerful MYSQL Manager and Admin Tool

This tool provides a better approach for RDBMS MySQL and is more like a GUI tool introduced by a company called Webyog, based in Bangalore, India. This guide is a MySQL manager and admin tool and involved in multiple tasks, one among them is combining the features of MySQL Query Browser, Administrator, phpMyAdmin and other MySQL Front Ends and MySQL GUI tools in a single resulting interface.

SQLyog is now available in two editions: Enterprise and Free Community Edition and from version 5.2 Community Edition has been available as Open Source (GPL license)

Features of SQLyog are:

• Visual Schema Designer
• Visual Query Builder
• Smart Auto complete
• Intelligent Code Completion
• HTTP/HTTPs Tunneling
• SSH Tunneling
• SSL Connections
• Wizard driven Migration Tool
• Data/Structure Synchronization [1]
• Fully Unicode support

This particular management tool works efficiently on the Windows platform from Windows 2000 to Windows Vista/Server 2008, and also works under Linux and various Unix’s (including Mac OS X) using the Wine environment and it is available in 3 other editions as well and is available in 3 other editions. On the other hand this tool is a pretty good option to go with, because the productivity tools of SQLyog Professional/Enterprise/Ultimate can save you countless hours by working with MySQL frequently. The recent changes that are made to SQLyog is Bug fixes.

In its discussion this tool involves in the execution of multiple queries/ selected queries/single queries offers a template explorer to insert commonly used queries like create table, insert, drop table, rollback and more and more importantly you can export data in CSV, HTML & XML format and Import from a text file.

GO4 SQLyog