Glossary Item Box

DBACentral for MySQL Submit feedback on this topic   

SELECT Query Wizard

This topic guide you through the process of generating the SELECT profile query within the Query Wizard. To learn how to start the wizard and how to select the query type see topic Query Wizard.

 

The first step of the SELECT Query Wizard allows you to select tables and columns to include into the query.

  

 

Select the table name from the Tables drop-down list and move table columns from the Available Fields list to the Selected Fields. Note, that you can select fields from multiple tables.

 

The next step of the wizard allows you to build conditions, which define the data selection criteria.



Please, examine the Designing Query Conditions for more details.

 

This step displays the list of query joins, based on the profile relationships. Query joins are intended for linking the selected data between tables.




The buttons below the join list are intended for managing the list: adding new joins, editing joins through the Join Properties  dialog, or deleting the joins.

 

With the next step of the wizard you can set additional query parameters.  



To learn more about such query parameters, as limitoffset and others, please refer to the Designing Query Options topic.

 

The final step of the wizard allows you to select the action to perform after the creation and displays information about the creation errors, if such occur.



Select Open the query in design mode to open the Query Designer after the query is created. To view the data of the new query within the Grid Data View, select Open the query for viewing data. To close the wizard without any action after creating the query, select the Take no action item.

 

To create the query with all the parameters you have set, click the Finish button.

 

 


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