SQLyog is an all-round Management Tool (/'GUI'/'Frontend') for the MySQL database. MySQL versions from 3.23 to 5.1.x are supported. SQLyog provides an efficient and intuitive User Interface for management of MySQL. It is at the same time an easy-to-use tool for beginners and an efficient timesaver for MySQL power users - Developers and DBA's as well.

SQLyog is a mature program that has been in existence for almost 5 years but now (Sept. 2006) released as Open Source under the GPL license. SQLyog 'development rate' is being continously accelerated. SQLyog runs on Windows and Wine (on Linux and other *nix variants where Wine is available). SQLyog has full support for MySQL 5.

Here are some key features of "SQLyog Community Edition":

· Nag Screen on startup displaying SQLyog Enterprise features
· Complete Unicode/UTF8 Support
· Developer / User Productivity
· Favorites Manager
· HTML Schema Documentation
· Shortcuts to generate SQL DML statements from schema definition
· Creating/Dropping/Altering tables
· Multi-tab Query Editor and Result-set Editor
· Multiple Query Execution
· Multi-threaded Query execution - Ability to stop long running queries
· SQL Templates
· Excel-style grid interface to view/update resultsets
· Multi-format Blob editor
· View data in Grid/Text Mode
· ResultSet/Data Export to CSV/XML/HTML/Excel
· Full Support from 3.23.38 to the latest 5.x
· Support for all MySQL table handlers
· Excel friendly resultsets/table-data export to clipboard/file
· Dialog-less table and resultset editor
· DBA Productivity
· Restoring / Importing large SQL dumps
· MySQL 5.x objects support
· User Management
· Managing hosted MySQL
· Connection Manager
· Index Management
· Relationship/Foreign Key Manager
· Reorder Columns
· Copy objects to another Host with single click
· Table diagnostics
· Flush Tools
· Object Browser
· Creating/dropping database
· Optimized for managing Hosted MySQL
· Multiple database connections
· Technology
· Turbo Speed MySQL Management. Uses native MySQL C API - the fastest way to communicate with MySQL server
· 100% keyboard friendly
· Small compact binary
· Minimal use of Registry - easy migration of User Preferences by dragging and dropping config files.
· Non-cluttered look and feel, ability to show/hide panes

What's New in This Release: [ read full changelog ]

· A calculation error could cause export tools to create BULK INSERT statements larger than specified by user.
· Import External Data Tool will now always map any autoincrement type from ODBC sources to a MySQL autoincrement integer. Before this datatypes that could autoincrement on source but not in MySQL (example: a SQL Server ‘decimal autoincrement’) failed to import.
· Now Import External Data Tool will convert SQL Server ‘GETDATE()’ to MySQL ‘now()’. Before this an error occurred at import with GETDATE()’s.
· Structure Sync will now query Information_Schema for a VIEW definition. MySQL sometimes returns ‘databasename.viewname’ and not just ‘viewname’ when using SHOW CREATE.
· Fixed a Object Browser flickering issue when refreshing.
· The fix in 8.15 for the issue that Windows Vista and higher could warn that SQLyog was not properly installed was not complete. It could still happen.