A value can be reset directly in the query:
- Using testdataset.testtable in the preceding example, enter the query in the following code into the query dialog and click on Run Query:
#standardSQL
UPDATE `testdataset.testtable`
SET impressions = 20000
WHERE campaign = 'summerdeals'
This should update the impression value to 20000 instead of the original 25000.
- A value can also be reset by applying arithmetic to a value or applying a function. Using testdataset.testtable in the preceding example, enter the query in the following code into the query dialog and click on Run Query:
#standardSQL
UPDATE `testdataset.testtable`
SET impressions = impressions - 5000
WHERE campaign = 'summerdeals'