To create a new update, click the “Create New Update" button located in the top right corner of the updates page.
The Create New Update box requires two pieces of information:
The Update name.
The Update SQL statement.
To name the update simply click in the “Name your Update” textbox and enter in the desired name.
To begin creating the SQL statement click in the “Enter Update SQL” textbox.
Here you are given a few options to make the writing of the SQL statement easier. In the box to the top right are all the tables and fields in the database which are listed for the user to search for the field they want to populate on the left-hand side of their statement. There is also a search function to make the process of finding a particular table or field easier.
The box to the bottom right is identical to the box on the top right but is used to populate a value for the right side of the SQL statement. Once all fields have been filled in, click the “Submit and Close” button to complete the process.