SQLyog provides you with powerful means to manage your MySQL databases.

    * FREE/COMMUNITY edition available
    * Runs on all Windows version from 98SE to Vista. runs on Linux with WINE.
    * MySQL 5.x compatible
    * Create/Drop/Alter Tables, Stored Procedures, Functions, Views and Triggers.
    * HTTP and SSH Tunneling - smartly manage your MySQL server even if the MySQL port is blocked or remote access to MySQL is disallowed!
    * Protect your data with SSL encryption
    * smart AutoComplete
    * Favorite Manager to neatly organize your favorite SQL statements.
    * very fast retrieval of data
    * Advanced GUI Query Builder. supports JOINs, aggregate as well as 'common' functions, sorting (ORDER BY) and filtering (WHERE and HAVING) and ALIAS
    * SQLyog Migration Toolkit - use the GUI or specify a query
    * structure and data synchronization tools
    * powerful scheduled backup with email notification
    * schedule various jobs
    * notification services - execute unattended queries for database maintanaince of data verification with feexible email option
    * update result returned from query - also supports queries with JOINs. No dialogues - just edit!
    * manage foreign key relationships
    * fully InnoDB compliant
    * supports MySQL pluggable storage engines architecture
    * multithreaded query execution with option to allow multiple query execution simultaneously
    * view your results in GRID / TEXT mode
    * filter data and resultsets directly form the context menu of a displayed value
    * 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
    * view and edit advanced table-properties, such as Comment, Key_Length etc
    * do table-diagnostics (check, optimize, repair, analyze)
    * dublicate tables to new table-names
    * excel like grid interface to edit data with support for Enum/Set
    * create/drop databases
    * manage indexes
    * comprehensive user/security manager. Control every available privilege on what level you like (server/database/table/column)
    * reorder columns of table
    * copy database between two MySQL hosts
    * drop all tables of a database with a single click
    * edit BLOBs in TEXT or GRAPICHS mode. All common (non-proprioritary) graphics format (including 'high-resolution' TIFFs and PNGs) supported.
    * export table-structure and data into SQL-dumps
    * direct export to Microsoft Excel
    * export/import data in/from CSV files
    * export database schema in HTML
    * log all queries for a session
    * syntax-highlighting
    * save resultset in CSV, HTML and XML
    * copy your result as CSV to clipboard
    * is very keyboard friendly. You can work with 99% features of SQLyog with keyboard.
    * view and kill other user-processes
    * flush Host/Logs/Privileges/Tables
    * quick acces to processlist, status, variables etc
    * and a lot more...