select

SELECT ALL

Select one or more tables and hit SELECT button.

Select table(s) and hit Select All button

The result of the query SELECT * FROM table_name will appear for each selected table. Each table is displayed with its own command bar and column list.

There are few values that can be applied to the SELECT statement: WHERE, GROUP BY, ORDER BY and LIMIT. Each value is used only if the corresponding field is filled out.

Result of SELECT query and query builder

Using form fields and column list the user can customize SELECT query for the each table individually. The customization persists until the user leaves the Select Results page.

By clicking on 'Go' button all the select results will be changed in accordance with form field values.

In case of multiple tables, "Exclude" checkbox appears for each table. Checking it you will exclude the corresponding table from the displayed result.

If 'SELECT' field is left blank, the selected columns of the column list will be used in SELECT query.

"Print Result" and "Export Result" button will appear if only one table is selected.

The following printing options are available:

Page title.
Title text style (Bolt, Italic and Underlined).
Title alignment: Left, Right or Center.
Height of the table header and height of the table rows: (min., 20 pixel, 30 pixel).

Export Result exports the result of the final SELECT query into a text file.

Previous

TOC

Next

[Home] [Products] [Screenshots] [Demo] [Manual] [Account] [Order] [Contact us]