Spanner supports the SELECT…FOR UPDATE query syntax in GoogleSQL and PostgreSQL-dialect databases
Share
Services
## Feature
Spanner supports the `SELECT…FOR UPDATE` query syntax in GoogleSQL and PostgreSQL-dialect databases. When you use the `SELECT` query to scan a table, add a `FOR UPDATE` clause to enable exclusive locks on the scanned data in order to reduce aborts for workloads that operate on the same data concurrently. This is similar to the `LOCK_SCANNED_RANGES` hint ([GoogleSQL](https://cloud.google.com/spanner/docs/reference/standard-sql/query-syntax#statement%5Fhints) and [PostgreSQL](https://cloud.google.com/spanner/docs/reference/postgresql/query-syntax#statement-hints)). For more information, see [Use SELECT… FOR UPDATE](https://cloud.google.com/spanner/docs/use-select-for-update).
What else is happening at Google Cloud Platform?
App Hub application labels are now attached to your log entries
about 17 hours ago
Services
Share
Google Distributed Cloud (software only) for VMware 1.30.700-gke.56 is now available for download
about 18 hours ago
Services
Share
Anywhere Cache for Cloud Storage is now generally available (GA)
about 19 hours ago
Services
Share