| execute multiple queries
returning more than 1000s of rows per resultset. Its very
efficient in memory very compact binary ( 490KB Installer
) 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)
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. |