SQLyog Community Edition description
|
A application that will allow you to manage MySQL databases.
SQLyog is an application designed to help users manage their MySQL databases easily. SQLyog is an all-round Management Tool for the MySQL database. SQLyog provides an efficient and intuitive User Interface for management of MySQL. It is at the same time an easy-to-use tool for beginners and an efficient timesaver for MySQL power users - Developers and DBA's as well.
SQLyog is a mature program that has been in existence for almost 5 years but now (Sept. 2006) released as Open Source under the GPL license. SQLyog 'development rate' is being continously accelerated. Here are some key features of "SQLyog Community Edition":
· MySQL 5.x compatible
· 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 maintainence of data verification with flexible 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
· 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
· 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)
· 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
What's New in This Release: [ read full changelog ]
Features:
· Added an option to specify the font used in the Object Browser
· Schema Sync now has an option to add SET FOREIGN_KEY_CHECKS = 0 to the script generated
· Added an option to specify INIT_COMMAND(s) for a connection. INIT_COMMAND(s) are executed when SQLyog connects and reconnects. The primary purpose is to override settings specified with ‘init_connect’ setting in server configuration for the SQLyog session. For instance if ‘init_connect’ server setting specifies “SET AUTOCOMMIT = 0" you may enter “SET AUTOCOMMIT = 1" in the SQLyog connection manager if you want a non-transactional behavior for the SQLyog session
Bug Fixes:
· If both a column default and a column comment was specified in CREATE/ALTER TABLE a SPACE-character was missing in the generated statement causing invalid syntax error. This bug was introduced in 9.5
· Fixed a crash (reported internally) in the ‘Indexes’ tab of the CREATE/ALTER TABLE interface
· Schema Sync did not handle BIT-column defaults properly. A redunda...
|
|