Show/Hide Toolbars

Navigation: Using PHPRunner > SQL query page

PHPrunner32x32     PHPRunner manual

SQL query page

Scroll Prev Next More


On the Edit SQL query page you can modify SQL query that PHPRunner has built for you automatically. In most cases you can proceed with default SQL query.

This page includes graphical panes that display your SQL statement (Query Designer tab), a text pane that displays the text of your SQL statement (SQL tab) and result of edited query as table with values (Results tab). You can work in either the graphical or text panes and then check result of executed query. Query Designer synchronizes the views so they are always current.


1. a visual interface to design queries

2. automatic SQL Statement generation

3. create joins with drag and drop

4. the grid pane to specify criteria (Order By, Group By, Where etc.)

5. SQL parsing - enter the SQL statement, and the diagram and grid will be populated