Using YQL to Read, Update, and Delete Records

Once you create a record using the yql.storage.admin Open Data Table, you can use the SELECT, UPDATE, and DELETE keywords with yql.storage to access, modify, or delete records, respectively.

Accessing Records using YQL

To read or access a record using YQL, use the following statement format that contains the SELECT keyword:

select * from yql.storage where name="store://08fd2c74-d393-48c4-9ee1-3bf7e5a1ec92"

Use the select access key that YQL provided to you upon creating the record. The YQL response contains a results element similar to the following:

Deleting Records using YQL

Use the DELETE keyword in YQL to delete a record, similar to the following:

delete from yql.storage where name="store://3cc85a99-6a89-4600-ade1-f7f83ecc4b83"

Use the update access key that YQL provided to you upon creating the record. The YQL response contains a results element similar to the following:

Updating Records using YQL

Use the UPDATE keyword in YQL to modify a record, similar to the following:

update yql.storage set value="new value" where name="store://3cc85a99-6a89-4600-ade1-f7f83ecc4b83"

Use the update access key that YQL provided to you upon creating the record. The YQL response contains a results element similar to the following:

Note

You can only update the contents of a named execute record to a URL on the same URL domain.

Table of Contents