SQLyog MySQL GUI is the most popular MySQL Manager and MySQL Admin Tool,combining the features of MySQL Query Browser, phpMyAdmin and various other MySQL Front Ends and MySQL Clients in a single intuitive interface. Working with MySQL can sometimes be painful. SQLyog has the ability to take even the most difficult and time consuming tasks and make them a breeze. SQLyog provides you with powerful means to manage your MySQL databases. * Runs on all Windows version from WinXP/2003 and higher as well as "Windows Server" systems of same generations (Windows Server 2003 and higher). * Works with MySQL servers from 4.1 and higher and all MariaDB servers. * Create/Drop/Alter Tables, Stored Procedures, Functions, Views, Triggers and Events. * 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. * Formats SQL statements. * Proactive Query Profiler. * 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 Import External Data wizard - use the GUI or specify a query. * Schema and Data synchronization tools. * Powerful compressed Scheduled Backup with email notification. * Schedule various jobs. * SQL Scheduler and Reporting Tool - execute unattended queries for database maintenance of data verification with flexible email option. * Full support for Virtual Columns of both Oracle/MySQL and MariaDB * GUI transactions support * Transparent LDAP/PAM support for connection to both Oracle/MySQL and MariaDB. No settings are required * 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. * Multi-threaded 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. * Tabbed interface to create/alter tables. * View and edit advanced table-properties, such as Comment, Key_Length etc. * Do table-diagnostics (check, optimize, repair, analyze) * Duplicate 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 access to processlist, status, variables etc. * and a lot more...