SQLyog is an easy to use tool that let's you manage your MySQL database anywhere in the world.

SQLyog is an easy to use tool that let's you manage your MySQL database anywhere in the world. SQLyog is a tool that allows you manage MySQL database.

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

Developer / User Productivity

· HTML Schema Documentation
· Shortcuts to quickly generate SQL statements and paste object names
· Learn MySQL by looking at the SQL generated by SQLyog
· Multi-tab Query Editor and Result-set Editor
· Multiple Query Execution
· Multi-threaded Query execution with option 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
· 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
· Dialogless 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
· Profiling
· 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:

· A new GRID design ("zebra" Office 2007 style) is used for easier navigation.
· Multiple selection can be done in GRIDs with Shift click.
· Data synchronization was improved.
· It is now typically 2-8 times faster than before depending on data.
· An option to generate a SQL sync script was added.
· The speed of exports was drastically improved.
· Automatic and manual update checks were added.