Query Result tab shows Results of Query which you can edit in an easy way. It is simple and just likes to use Excel like grid interface.

SmartMySQL Query Result tab also shows you information about DBs and Tables and all the query(s) that have been executed in the current connection. it has three tabs - Data, Object and History and three context-specific tabs - Result, Profiler, and Message. Profiler tab opens if the Query Profiling feature is enabled.

SmartMySQL returns a resultset When you execute a query, a new Result Tab is added at the beginning of the tab window. multiple Result tabs would be created containing the resultset of the respective queries if you execute multiple queries.  

Note that in SmartMySQL, MySQL result set can be updated from the RESULT tab.  

To copy the resultset to clipboard Right click on result window->Copy-> Choose the below options as per requirement.

• Right click on result window->Copy->Copy cell data to the clipboard to copy only selected cell data to the clipboard.
• Right click on result window->Copy->Copy All Rows to the clipboard to all resultset data to the clipboard in CSV format.
• Right click on result window->Copy->Copy Selected Row(s) to the clipboard to copy all selected data to clipboard in CSV format.
• Right click on result window->Duplicate Current Row to duplicate only the focussed row of the resultset data as a new row in Table Data.

To export resultset data in various formats like HTML, XML, CSV, PDF just right click on Result window->Export All Rows of Table Data/Result set as

On double click in a very cell within the data GRID and on click on the calendar icon in FORM-view, calendar management for managing DATE, DATETIME and TIMESTAMP columns pops up. In GRID-mode it’s like this:

And in FORM-MOde  it’s like this:

From pop up, you may select the date from the calendar and modify the time using time controller.

 

The form mode displays the present record: with all the field names on the left and therefore the corresponding values on the right.it’s attainable to look at a complete row of information directly. Inserting a new row, change associate degree existing row, deleting and filtering are attainable. The navigation option at the bottom of the form allows  you to browse successive records as well as goto the very first and the very last record.. The context menu (generated on right click in form mode) provides options to perform custom filter, set the cell value to Empty / Null / Default, Export Copy, Duplicate the present row, Delete selected row, Cancel and Save changes.you can enable the form mode option  by choosing the form option within the data tab.

 

The Grid mode displays the resultset in excel like columns & rows. You can enable the Grid mode option by choosing the form option within the data tab. You may click on the header to sort the results of the column. This sorting is done on the client side without sending any query to the MySQL server.

 

The text mode displays the resultset in textmode separated by space. You can search for a particular string in the resultset by selecting EDIT->FIND or(press CTRL+F). You can enable the form mode option by choosing the form option within the data tab.

You can control the number of output resultset rows by using limit rows option from the data tab. You can see up to 1000 records without choosing a limit.

 

 

Messages tab shows the information about SQL queries execution like how many rows returned/inserted/updated/deleted. It also provides you query execution time and warning messages if you enable. You can enable warnings from Tools->Settings/Preferences ->General ->Show messages in the result tab. You can select  different options like ‘queries with errors’,’ Queries with errors and warnings’ … from drop down

 

Info tab displays information about database objects like a  database, tables & other database objects like views, functions …..The information can be displayed using HTML format or using TEXT/DETAILED format.

HTML format:

TEXT/DETAILED format:

 

Profiler tab occurs in the resultset panel after executing the select query if  ‘Query profiler‘ feature is turned on.

It displays the change of status variables due to the execution of a query.

Also gives the( Explain SELECT… ) output of the executed query. Explain plane result gives important information for tuning the query to improve server performance.

Also gives (Explain extended select …) gives explain plane output followed by show warnings. Show warnings output returns optimizer converted query during execution.