UPDATE

Data Model > Accessing the UNICOM Intelligence Data Model > Working with the Case Data Model > SQL syntax > Data manipulation statements > UPDATE

UPDATE

The UPDATE statement changes existing data in a table.

Syntax

UPDATE
table
SET
column = expression [, column = expression... ]
[ WHERE
expression ]

Notes

The UPDATE statement does not support the FROM clause, when it is used to include information from other tables in the WHERE expression.

For information about including special characters in the text when updating a text variable, see Inserting and updating text variables.

Example

See Using the examples in this section.

This example updates respondent number 603, which you added to the table in the INSERT example. The UPDATE example gives values to the visits and entrance columns.

UPDATE vdata
SET visits = 10, entrance = {side}
WHERE serial = 603

After running the example, you can check the values using the following query:

SELECT serial AS Serial,
gender AS Gender,
museums AS Museums,
name AS Name,
visits AS Visits,
entrance AS Entrance
FROM vdata
WHERE serial > 601

Here is the result set:

Serial Gender Museums Name Visits Entrance
------ -------- ------------------------------------------------- ------------ ------ --------
602 {female} {northern_gallery} 2 {main}
603 {female} {national_museum_of_science,national_art_gallery} Tanya Smiley 10 {side}

The Visits and Entrance columns have been updated for respondent 603.