How do I create update queries to update database information?
|Top « Previous Next »|
An UPDATE query is used to alter an existing record in a database table.
Warning: Great care needs to be taken with update queries. Update queries first search for all records which match a condition and then update ll those matched records with the new information. We suggest testing on a test database and even then only updating to a mirror of the main database.
When you create an update query, links to create a new condition and value are shown in the query builder. Enter conditions to find the fields and records for which their values will be updated, then add values for the changed records.
You'll need to add in the values of each field which are constant, otherwise they will be [UserInput], ie. from the end-user