How to use SQLYog ?

Create new DB connection

1. Open SQLYog. It will open Connect to MySQL host dialog.

2. Click new... butoon.

3. Give connection name, and click OK.

4. Provide host, username, password, port and DB name (optional).

5. Click Save button.

Test or Connect a saved connection

1. Select a connection from saved connection list. It will load all details of that connection.

2. Click Test Connection... button for testing the DB availability.

OR

Click Connect button for connecting to DB.

File menu

File > New connection : Connect to a new or saved connection.

File > Disconnect : Disconnect from the opened connection.

File > New query tab : Open a new query tab in Query window.

File > Open : Open queries from .sql file to Query window.

File > Save : Save queries which you have in Query window to .sql file.

View table data

TABLE DATA TAB OF RESULT PANE

Table > View data : Opens table data in grid view.

You can directly edit the data in grid cells.

Icons present in toolbar attached to grid :

1. Save changes : Saves changes made to grid data.

2. Delete selected row(s)

3. Cancel changes: Cancels changes made to grid data.

4. Show all: Shows all the data and rows present in table.

5. Limit : Sets upper and lower limits of the rows to display in grid.

6. Refresh button : Refresh grid data. If any changes made to the table data, it will be reflected.

OBJECTS TAB OF RESULT PANE

In this tab, you can view following details of selected table :

1. Column Information

2. Index Information

3. DDL Information (CREATE TABLE QUERY)

Edit > Show results in text: ON/OFF grid view or text view.

Other panes can be ON/OFF using :

Edit > Object browser

Edit > Result pane

Edit > SQL editor

Running queries

Write any query in Query window.

If you have more than one query, just select the query to be executed.

Press F5 to run query.

OR

Go to Edit > Execute query > Execute current query.

To execute all queries you have in Query window.

Go to Edit > Execute query > Execute all queries.

(Note: There should be a semicolon at end of each query.)

RESULT TAB OF RESULT PANE

On execution of select query, result is displayed in Result tab.

Icons present in toolbar attached to grid :

1. Export resultset: Export result data to file of many formats (XML, HTML or CSV)

2. Copy selected cell data to clipboard

3. Copy all rows to clipboard (which can be paste in Excel or text file)

4. Copy selected rows to clipboard (which can be paste in Excel or text file)

MESSAGE TAB OF RESULT PANE

On execution of add, update or delete query, result (no. of rows affeted) is displayed in Message tab.

HISTORY TAB OF RESULT PANE

Have all the commands and actions executed before along with displaying time of execution.