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 2

By DatabaseJournal.com Staff


Executing Queries

You execute all your SQL commands in the SQL window. To help you out with SQL syntax, SQLyog provides templates for all the SQL supported by MySQL. You can get to the template window by selecting Edit -> Insert Templates (Ctrl+T).

There are three methods of executing queries in SQLyog -- Execute Current Query (F5), Execute All Query(s) (Shift+F5) and Execute Selected Query (Ctrl+F5). If you have written multiple queries and want to execute a particular query, then place your cursor in the respective query and press F5.

When you execute a query that returns a resultset, a new Result tab is inserted in the Result window. If you have executed multiple queries that produce multiple resultset(s), then you will have multiple Result tabs in the window, with the resultset of the respective query attached to it. If you double click on a BLOB column, SQLyog would try to parse the BLOB data to find out whether it is a valid text/image file and then display the contents in a modeless dialog. All popular file formats like (GIF/JPEG/PNG) are supported.



Toggle between GRID/TEXT modes to view results by selecting Edit -> Show Results In Text (Ctrl+L). While in grid mode you can click on the header to sort the results on that column. This sorting is done on the client side without sending any query to the MySQL Server. You can also apply simple filters on the result set by selecting the Filter option in the right-click context menu.



Viewing result sets in text mode is very helpful if you want to cut and paste plain text into another application. While viewing a result set in text mode, you can also search for a particular string in the result set by selecting Edit -> Search from the menu.


Page 3: Exporting Resultset in XML, HTML, CSV Formats




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


















Thanks for your registration, follow us on our social networks to keep up-to-date