Queries

A query in DBACentral for MySQL is a specific object, stored in a profile file, which contains a single SQL statement or a number of statements. The SELECT-based queries are intended for viewing data, selected from different tables by some criteria. DBACentral also supports INSERT, UPDATE, and DELETE queries, which are intended for modifying data in database tables, and queries, containing custom SQL statements: e.g. SHOW, CREATE TABLE, etc.

The list of queries, stored in a profile, can be viewed and modified at the Queries Page of the Main Profile Window.

You can create a new query in several ways:

1. Create a new query in Design View by double-clicking at the Create query in design view item on the Queries profile window page.
2. Create a new query using the Query Wizard by double-clicking at the Create query by using wizard item on the Queries profile window page.
3. Create a query by typing in the SQL text in the SQL View of Query Designer by double-clicking at the Create query in SQL View item on the Queries profile window page.
4. Creating an auto-query from the Table Data View by adjusting visible columns and filtering of the grid and selecting the Auto Object | Auto Query item from the popup menu.

To open the existing query for viewing or modifying data, simply double-click at its name on the Queries profile window page.

To change the query text select its name at the Queries page and click the Design button on the toolbar or in the popup menu. This opens the Query Designer in the design or SQL mode, depending on the type of query creation.

To delete a query from the profile, select its name at the Queries page and click the Delete button on the toolbar or in the popup menu.

©2004 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.