SQLyog is a easy to use, compact and very fast graphical tool to
manage your MySQL database anywhere in the world.
Features of SQLyog :
-MySQL 4.1 compatible
-very fast retrieval of data
-ODBC Import with option to import data through query
-database synchronization tool
-update result returned from query
-manage foreign 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. -very compact binary ( 484KB Installer )
-written entirely in C/C++/Win32 APIs using native MySQL C APIs.
-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)
-and a lot more...
SQLyog was developed keep in mind the necessities of all who use
MySQL as their preferred RDBMS. Whether you enjoy the control of
handwritten SQL or prefer to work in a visual environment, SQLyog
makes it easy for you get started and provides you with tools to
enhance your MySQL experience. http://www.webyog.com/sqlyog/index.
html
Download File Size:2.25 MB