Query Tool

The query tool is used to perform database operations. First, select the tools and its options. Then, click on the "Process" button at the toolbar.

1. Table List

This tool displays all the database tables. There are no other options.

2. Table Columns

This tool displays all the columns in the database table. You can use this tool to know about database columns before using any other query on the database.

Type: Select the database table.

If you run this tool before any other tool, the table type will be automatically selected.

3. Table Create

This tool displays the table create statement for the selected table.

Type: Select the database table.

4. Update

This tool updates the column of the selected table with the value.

Value: The value that will be updated.

Type: The database table

Column: The column where value will be updated.

Filter: Add filters to update records selectively. Otherwise all the records in the table will be updated.

5. Find

This tool performs a search in the column for the selected table. It displays the IDs of the records where the search is successful.

Text: The value you want to search.

Type: The database table.

Column: The column where text will be searched.

6. Replace

This tool finds and replaces the text with the value in the column of the selected database table.

Text: The value you want to find and replace.

Value: The value with which text will be replaced.

Type: The database table.

Column: The column where find and replace tool will run.

Filter: Add filters to update records selectively. Otherwise all the records in the table will be updated.

7. Delete

This tool deletes the records from the selected database table based on the filters.

Type: The database table.

Filter: Add filters to delete records selectively. Otherwise all the records in the table will be deleted.

8. Truncate

This tool truncates (deletes all records and resets) the table.

Type: The database table.

9. String

This tool applies a string function to a column in the selected database. You can save the result in the same column or in a different column.

String Function: Select the string function to apply.

Parameters: Add the parameters if applicable to the string function.

Type: The database table.

Column: The column where to apply the function.

Column to Save: The column where to save the value after applying the string function.

10. Date

This tool applies a date function to a column in the selected database. You can save the result in the same column or in a different column.

Date Function: Select the date function to apply.

Parameters: Add the parameters if applicable to the selected function.

Type: The database table.

Column: The column where to apply the function.

Column to Save: The column where to save the value after applying the string function.

11. Numeric

This tool applies a numeric function to a column in the selected database. You can save the result in the same column or in a different column.

Numeric Function: Select the numeric function to apply.

Parameters: Add the parameters if applicable to the numeric function.

Type: The database table.

Column: The column where to apply the function.

Column to Save: The column where to save the value after applying the string function.