As you continue to work with SQLyog, you will notice that SQL statements, along with the time they have taken to execute, are
getting recorded in the History tab of Result Window. Apart from logging
the SQL that you have typed in the SQL window, SQLyog also logs all SQL that it
sends to MySQL to provide you with a GUI interface. This helps a lot in a
couple of things like:
- Profiling - You now know how much
time a SQL statement took to execute. This information would be of great help
in optimizing your queries, deciding when to create indexes, etc.
- SQL Tutorial - Looking at this log is probably the best way to learn MySQL! You can find out all the commands
SQLyog sends to MySQL for displaying a GUI interface to you.
You can create a new Table in a database and alter the
structure of an existing table in an easy to use Excel like GRID environment.
To create a table in a database select the database in the Object Browser and
select DB -> Create Table In The Database... or press (Insert).
Just fill in the details and Press Create Table. If
you want to provide some advanced properties like Comment/Table Type/Checksum etc., you can do this by pressing Other Properties. It provides
you with a dialog box that allows you to provide all table properties.
Similarly, alter the structure of an existing table by
selecting the particular table in the Object Browser and select Alter Table
Structure... or press (F6). Just change the details in the Grid and
press Alter Table. To cancel the changes at any
point of time while altering a table, press Cancel.
Indexes help the database store data in a way that makes for
quicker searches. You can create/edit indexes in a table by using SQLyog's
Index Manager. To view the existing Indexes in a table, select the table in
Object Browser and select Manage Indexes from the popup menu.
To create a new Index press the New button. Check the
column(s) on which you want to create the index. SQLyog is very flexible in
index management. You can change the order of the columns by using the Up/Down
button and even index on the first "n" characters of a column or make an Index
To edit an existing Index, select the Index and press the
Edit button and apply your changes.
Page 5: Backing Up/Restoring Data