welcome

sqlyog

contact us

General
Questions

Q. What is SQLyog ?

A. SQLyog is a very fast,
compact and simple to use GUI tool to manage
your MySQL server. The software is primarily for the users who
work with MySQL during the development process.

Like MySQL, SQLyog also follows the principle of
the 14th century philosopher monk Occam. We follow his rule
known as Occam’s razor: No complexity beyond what is
necessary.

Q. Which is the latest version of SQLyog
?

A. The latest version of SQLyog is 2.51,
released in the third week of November 2002. It contains so
many new features that it is a must upgrade for all from
SQLyog 1.71.

Q. Where can I obtain
SQLyog ?

A. You can download a copy of SQLyog from the
SQLyog
Download Page. Just provide us with your name and e-mail
address so that we can inform you about future releases of
SQLyog.

Q. Is there any mailing list for SQLyog
?

A. As of now we don't have a mailing list for
SQLyog. You can communicate directly to us regarding any
problems/queries/suggestions about SQLyog using this form.

Q. I think I found a bug, whom should I tell
?

A. Make sure that you are using the latest
version of SQLyog by checking it at the SQLyog website. If you
are sure that you have the latest one then please use the Bug
Reporting form at Bugs
Page . We will reply you back about the status of the bug.
If its a known bug then we will be able to reply back with the
solution or maybe you have to wait for the next release.

Q. Do I need to read any
documentation to put SQLyog into use ?

A. Absolutely not. SQLyog has got an intuitive
interface, you will be up and running within moments. Special
care has been taken to provide a non-cluttered and extremely
simple interface.

Technology

Q. I am new to MySQL/SQL ? Can SQLyog
help me in learning MySQL ?

A. Yes! If you are new to MySQL or SQL then
SQLyog is the ideal tool to get you started. Apart from
providing templates of all SQL statements supported by MySQL,
queries generated by SQLyog to perform various tasks are also
logged. click
here to see a screenshot of query profiler

Q. On what platform SQLyog has been
developed ?

A. SQLyog has been written using C/C++/Win32
APIs. It accesses MySQL using the native MySQL C API and does
not uses any wrapper classes. This makes SQLyog probably the
fastest front end to MySQL in the market. Moreover the size of
SQLyog binary is one of the smallest. ( < 348 KB )

Q. Do you have any plans to release a
Linux/Unix version of SQLyog ?

A. Yes. We may make SQLyog cross platform in
our next major release.

For
Developers

Q. I would like
to get my results in text form so that I can search for a
string or copy portions of resultset as text to the clipboard.
Is it possible ?

A. SQLyog allows you to view your
resultset in Grid as well as Text Mode. You can toggle between
the modes by pressing Ctrl+L. In the Text mode set your cursor
in the result pane and press Ctrl+F to search for a string. click
here to see a screenshot of result in text

Q. I have a very
big query and I would like to use the complete screen area for
editing. How can I do that ?

A. SQLyog allows you to show/hide
both the Object Browser and the Result Pane. Therefore by
hiding both of them you can use the complete space in editing
your query. You can show/hide Object Browser by pressing
Ctrl+1 and show/hide Result Pane by pressing Ctrl+2.

Q. I have a huge
SQL batch file ( in gigabytes! ). How can I execute it using
SQLyog ?

A. SQLyog allows you to execute a
batch file of any size (yes....any size - limited by the OS).
Select Tools -> Execute Batch File (Ctrl+Shift+Q). Select
the file and press Execute. If SQLyog encounters an error it
stops further execution and logs the query as well as the
error message in sqlyog.err located in the SQLyog installation
folder. click
here to see a screenshot of execute batch file dialog
box

Q. I want to
export the resultset in a file on the client. The MySQL
command SELECT INTO OUTFILE... creates a file on the server
only. Can SQLyog create a file on the client ?

A. After you execute a query. Select
the tab of the particular resultset which you want to export
and right click on it ( Ctrl+Shift+E ) and select Export
Resultset. SQLyog allows you export the result set in XML,
HTML, CSV ( fixed length and variable length ). click
here to see a screenshot of export resultset dialog
box

Q. Can I export
data in fixed length format using SQLyog ?

A. Yes! Apart from the usual variable
length format SQLyog can export/import fixed width format
data. Select the table in the Object Browser for which you
want to export the data and select Table -> Export Table
Data As CSV ( Ctrl+Alt+C ). Select Fixed Length in the
escaping characters dialog box (you get this by pressing the
Change... button). click
here to see a screenshot of export table data in CSV

Q. I want to
create a documentation of my database ? Does SQLyog provide
any tool for creating a schema document ?

A. Yes! SQLyog allows you to build a
printer friendly schema document in HTML. You can either
select the entire database or specific tables. Select the
database -> right click -> Create Schema For The
Database in HTML (Ctrl+shift+S). click
here to see a screenshot of schema created by SQLyog

Q. I have
created a table and would like to insert sample data
quickly...Do I need to write insert statements ?

A. No! SQLyog provides you with an
Excel like Grid to Insert/Update data through which you can
insert data quickly. Moreover, you can use the tool to insert
blob data.

Q. I have got a table that has blob fields
containing text/images...Can I view / modify BLOB fields
?

A. Yes! Select the table in the
Object Browser and select Table -> Insert / Update Data (
Ctrl+Enter ). You can insert/edit/save any type of BLOB data.
By default SQLyog will only show you the top 50 rows of the
table but you can change the limit by changing the limit
values in the top. It automatically detects popular image
formats like JPG/GIF/PNG and displays them. Moreover you can
save BLOB data to a file or import contents from a file to a
BLOB column. click
here to see a screenshot of Insert / Update data dialog
box

Q. I have a
resultset which has a BLOB column ? How can I view its data /
save it ?

A. All the BLOB columns will be shown
in the Resultset window with [BLOB] [size of data in bytes].
Double click on the column and a modeless Blob Value
dialog box will popup. You can save the data in a file in your
local machine by selecting Save Data To A File option.
Therefore, for example, you can even retrieve a PDF data in a
column and save it in your harddisk. click
here to see a screenshot of blob value dialog box

Q. I have a table with lot of
columns and I want to generate an Insert statement for the
table. How can I do it ?

A. Select the table in the Object
Browser and select Table -> Insert Statement For The Table.
SQLyog will create a insert statement for the table and you
just need to fill in the appropriate values.

Q. Just like
other programmers, I like to do most of my work using keyboard
? Is SQLyog keyboard friendly.

A. SQLyog has been designed from
ground-up to be keyboard friendly. You can switch between the
various panes, multiple resultsets without ever needing the
mouse. Check out
the various keyboard shortcuts provided by SQLyog.

Q. I have
retrieved a resultset in SQLyog. Now, I want to quickly
sort/filter the data without changing and re-executing the SQL
query. How can I do that ?

A. If you are viewing the result in
Grid mode, you can click on a column header to sort the
resultset on that column. You can use the Right Click context
menu to filter data. Furthermore, you can combine sorting and
filtering. click
here to view a sorted column

For
Administrators

Q. Can I alter
existing Table structures ?

A. Yes! You will get a Excel like Grid to alter
your table structure. click
here to see a screeshot of alter table dialog

Q. Can I manage Indexes using
SQLyog ?

A. Yes! SQLyog provides you with an easy Index
Manager. You can manage multiple indexes, create indexes on
multiple columns, change the order of columns in the index,
etc. click
here to see a screeshot of manage indexes dialog

Q. I want to add users / change
passwords etc. ? How can I do that ?

A. Use Tools -> User Manager -> Add Users
( Ctrl+U ) and Tools -> User Manager -> Edit Users (
Ctrl+Alt+U ) to add and edit users global privileges. click
here to see a screeshot of edit user dialog

Q. I want to give a user
privileges only to particular columns in a table ? Can I do it
in SQLyog.

A. Yes! By using SQLyog's powerful and easy to
use Manage Permissions tool, you can give database, table
& column level privileges to any user. The Manage
Permissions option can be found at Tools -> User Manager
-> Manage Permissions (Ctrl+Shift+W). click
here to see a screenshot of manage permissions

Q. My MySQL Server is hosted with
an ISP. How can SQLyog help me in remote administration
?

A. SQLyog has been specially designed to work on
remote connections. It is very efficient on network bandwidth
giving you the best possible environment to work with MySQL
server on remote connections.

Q. I have a bunch of
administrative SQL scripts which I use frequently. I don't
want to save and load files every time ? How can SQLyog help
me in saving time ?

A. SQLyog allows you keep your frequently used
SQL scripts in a Personal Folder. To save a SQL query press
Ctrl+Shift+F and provide a name. When you want it back, press
Ctrl+Shift+P and select the query name from the popup menu.
SQLyog allows you to have 99 SQL queries in the personal
folder. click
here to view personal folder menu

Q. How do I diagnose/optimize
tables ?

A. Use Tools -> Table Diagnostics and select
the database and tables and click on the operation you want to
perform. SQLyog provides all types of diagnostics provided by
MySQL with a single click. click
here to see a screenshot of table diagnostics dialog
box

webyog
mysqlyog sqlyog mysql front end mysql client mysql query
analyzer sql mysql GUI structured query language mysql windows
tool editor front end front-end gui graphical client query
analyzer development environment IDE win32 simple fast easy
beginner dummy

SQLyog

Download

What's
New

Screen
Shots

Keyboard
Shortcuts

Help
for SQLyog

FAQ

Suggestions

Bug
Report

Questions

webyog, 2002-2003
all
rights reserved