If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

features of “SQLyog”:

· MySQL 4.1.x compatible
· 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 notifications
· schedule various jobs
· schema synchronization tool
· dialogless result editor with option to update multiple tables
· notification services
· multithreaded query execution with option to stop long running queries
· manage foreign key

relationships
· fully InnoDB compliant
· view your results in GRID / TEXT mode
· fast client side sorting and filtering
· 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)