Glossary Item Box

DBACentral for MySQL Submit feedback on this topic   

DELETE Query Wizard

This topic guide you through the process of generating the DELETE 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 DELETE Query Wizard allows you to select tables to include into the query.


 

Move tables from the Available Tables list to the Selected Tables.

 

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



Please, examine the Designing Query Conditions for more details.

 

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



To learn more about such query parameters, as low priority or ignore errors, 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 execute the query and apply the selected modifications to table data, select  Execute the query. 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.