Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MySQL

Posted Dec 18, 2002

Introducing SQLyog, a MySQL Front End - Page 3

By DatabaseJournal.com Staff


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




MySQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MySQL Forum
Topic By Replies Updated
MySQL in high availability and transction secure banking application klamor 1 August 28th, 10:24 AM
MySQL rollback UAL225 1 August 28th, 10:15 AM
Browsing a DB file that uses MySql finleytech 1 July 26th, 10:51 AM
php cookie won't pass variable to next page ITdevGirl 0 June 22nd, 12:13 PM