fix: use DELETE FROM for consistency (GoogleCloudPlatform#3498)

skuruppu · gcf-merge-on-green[bot] · Takashi Matsuo · web-flow · commit 692730daee84 · 2020-04-28T14:28:43.000-07:00
Being consistent with [docs](https://cloud.google.com/spanner/docs/dml-syntax#delete_examples). Co-authored-by: gcf-merge-on-green[bot] <60162190+gcf-merge-on-green[bot]@users.noreply.github.com> Co-authored-by: Takashi Matsuo <tmatsuo@google.com>
diff --git a/spanner/cloud-client/snippets.py b/spanner/cloud-client/snippets.py
@@ -831,7 +831,7 @@ def delete_data_with_dml(instance_id, database_id):
 
     def delete_singers(transaction):
         row_ct = transaction.execute_update(
-            "DELETE Singers WHERE FirstName = 'Alice'"
+            "DELETE FROM Singers WHERE FirstName = 'Alice'"
         )
 
         print("{} record(s) deleted.".format(row_ct))
@@ -1055,7 +1055,7 @@ def delete_data_with_partitioned_dml(instance_id, database_id):
     database = instance.database(database_id)
 
     row_ct = database.execute_partitioned_dml(
-        "DELETE Singers WHERE SingerId > 10"
+        "DELETE FROM Singers WHERE SingerId > 10"
     )
 
     print("{} record(s) deleted.".format(row_ct))

Original file line number	Diff line number	Diff line change
`@@ -831,7 +831,7 @@ def delete_data_with_dml(instance_id, database_id):`
`831`	`831`
`832`	`832`	`def delete_singers(transaction):`
`833`	`833`	`row_ct = transaction.execute_update(`
`834`		`- "DELETE Singers WHERE FirstName = 'Alice'"`
	`834`	`+ "DELETE FROM Singers WHERE FirstName = 'Alice'"`
`835`	`835`	`)`
`836`	`836`
`837`	`837`	`print("{} record(s) deleted.".format(row_ct))`
`@@ -1055,7 +1055,7 @@ def delete_data_with_partitioned_dml(instance_id, database_id):`
`1055`	`1055`	`database = instance.database(database_id)`
`1056`	`1056`
`1057`	`1057`	`row_ct = database.execute_partitioned_dml(`
`1058`		`- "DELETE Singers WHERE SingerId > 10"`
	`1058`	`+ "DELETE FROM Singers WHERE SingerId > 10"`
`1059`	`1059`	`)`
`1060`	`1060`
`1061`	`1061`	`print("{} record(s) deleted.".format(row_ct))`