Being a desktop application, with SQLyog you don't have to wait for page-refreshes of your browser like in web-based MySQL administration tools. Also context-sensitive menus and inline-help is immediately available and a full-featured set of user-friendly keyboard-shortcuts as well.

General Features

Internationalization
- 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
Feratures specific to Enterprise Edition

Visual Tools
- Visual Schema Designer  
- Visual Query Builder  
Enhanced Services
- Priority access to BETAs, new versions and patches  
- Unlimited ticket-based support for one year  
Enhanced Productivity 
- Smart Autocomplete  
- Intelligent Code Completion  
Advanced Connectivity Options 
- HTTP/HTTPs Tunneling  
- SSH Tunneling  
- SSL Connections  
Migration Tools 
- Wizard Driven Migration Toolkit  
- Import tasks can be scheduled  
Synchronization Tools 
- Schema Synchronization  
- Data Synchronization  
- Data Synchronization can be scheduled  
Other Power Tools 
- Scheduled Backups  
- Notification Services  
- Job Manager  
Trial version limitations
- In the startup as well as in exit it will show a window displaying how many days left in the trial period.
- Once the trial period is over it will exit immediately after showing the trial period expired window. The connection window will not appear.
- Data Sync will allow to sync only two tables per job executed.
- Scheduled Backup will allow only two objects to be exported per job executed. The two objects may be of identical type or different type (Tables, Stored Procedures etc.)
- Migration Toolkit will allow only 2 tables to be imported/migrated per job executed.
 

Requirements:

· Windows 98SE - Vista
· Linux requires WINE