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 interface.

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 client machine.

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 Result Window.

Page 4: SQL History