SQLyog MySQL GUI - Community Edition for Windows Publisher: Webyog Softworks Platform: Windows 9x/ME/NT/2000/XP License: Freeware Downloads: 57

SQLyog community edition is an open source Windows based MySQL client that provides you with powerful means to manage MySQL database engine from a graphical front-end. It's quite similar to Microsoft SQL Server's Query Analyzer.

SQLyog community edition is FREE and contains ALL features of SQLyog Enterprise except the following Power Tools:

HTTP / SSH Tunneling
Data Synchronization
Schema Synchronization
Notification Services
ODBC Import
Scheduled Backups

You can install and use SQLyog FREE edition on unlimited number of computers without any restrictions. SQLyog is well behaved - it does NOT contain any ADWARE or SPYWARE.

Download SQLyog FREE edition now and make your development more enjoyable.

Major functionalities of SQLyog:

• HTTP and SSH Tunneling - smartly manage your MySQL server even if the MySQL port is blocked or remote access to MySQL is disallowed!
• Very fast retrieval of data.
• ODBC Import with option to import data through query.
• Data synchronization tool.
• Powerful scheduled backup with email notification.
• Schedule various jobs.
• Schema synchronization tool.
• Notification services.
• Update result returned from query.
• Manage foreign key relationships.
• Fully InnoDB compliant.
• Dialogless result editor with option to update multiple tables.
• Multithreaded query execution with option to allow multiple query execution simultaneously.
• View your results in GRID / TEXT mode.
• Execute (very large) SQL-scripts as batch files.
• Execute multiple queries returning more than 1000s of rows per resultset. Its very efficient in memory.
• Very compact binary.
• Written entirely in C/C++/Win32 APIs using native MySQL C APIs. No wrapper classes used.
• Connection manager.
• Excel like grid interface to create/alter tables.
• Excel like grid interface to edit data with support for Enum/Set.
• Create/drop databases.
• Manage indexes.
• Comprehensive security manager. Control access to databases/tables/columns.
• Reorder columns of table.
• Copy database between two MySQL hosts.
• Drop all tables of a database with a single click.
• Edit BLOBs with Bitmap/GIF/JPEG-Support.
• Export table-structure and data into SQL-scripts.
• Export/import data in/from CSV files.
• Export database schema in HTML.
• Log all queries for a session.
• Profile queries.
• Syntax-highlighting.
• Save resultset in CSV, HTML and XML.
• Save your commonly used SQL scripts in a personal folder with a click of mouse.
• Is very keyboard friendly. You can work with 99% features of SQLyog with keyboard.
• View and kill other user-processes.
• View advanced table-properties, such as Type, Comment, Key_Length and so on.
• A list of server-variables e.g processlist, status, variables etc.
• Copy your result as CSV in clipboard.
• Copy tables to new table-names.
• Change table-types to ISAM, MYISAM, MERGE, HEAP, InnoDB, BDB.
• Flush Host/Logs/Privileges/Tables.
• Do table-diagnostics (check, optimize, repair, analyze).
• and a lot more....