Exporting Resultset in XML, HTML, CSV Formats
Options to export Resultset are one of the most important
features you can get from a front end. Using SQLyog, export your resultset in
XML, HTML or CSV format. To work with this option just select a valid Result
tab in the Result Window and click on Tools -> Export Resultset.
SQLyog lets you overcome the limitation of MySQL's SELECT
INTO OUTFILE... that allows you to dump data from a resultset to a file on
the server. Using SQLyog you can save the file in your client machine. All
options available in the SELECT INTO OUTFILE are presented with a neat GUI
You can even copy your Resultset in Clipboard by right
clicking on the Result window and selecting Copy Data To Clipboard/Copy
Selected Data To Clipboard.
Insert/Update Data In A Table
Manipulating data is also simplified
through the use of SQLyog. To work with the MySQL data, simply click on the
table in the Object Browser and select Insert/Update Data from the
context menu. In this area, you will see the data displayed in a familiar
spreadsheet-like format. To edit an existing record, simply click on the
desired field and key in the new information.
Adding a new record is accomplished by keying in new
information in the blank row at the bottom. If any of the columns in the table
are of BLOB type, SQLyog will show a button that opens up the BLOB editor.
Through this you can Insert binary/text data into the table. It allows you to
edit existing data, and you can even save the BLOB data as a file into your
Getting Information About Database/Tables
The Objects tab in the Result Window gives you information
about a particular database/table. View the information by double-clicking on
the particular object in the Object Browser and information will show up in the
Page 4: SQL History