Summary of YQL Statements
The following table lists all YQL statements:
| Statement | Example | Description |
|---|---|---|
| SELECT | SELECT * FROM social.profile WHERE guid=me |
Retrieves data from the specified table. See the SELECT Statement chapter for more information. |
| INSERT | INSERT INTO table (key1, key2, key3) VALUES ('value1', 'value2', 'value3')
|
Inserts data into the specified table. See the INSERT, UPDATE, DELETE statements chapter for more information. |
| UPDATE | UPDATE (table) SET field1=value WHERE filter |
Updates data in the specified table. See the INSERT, UPDATE, DELETE statements chapter for more information. |
| DELETE | DELETE FROM (table) WHERE filter |
Deletes data in the specified table. See the INSERT, UPDATE, DELETE statements chapter for more information. |
| SHOW TABLES | SHOW TABLES |
Gets a list of the tables available in YQL. |
| DESC | DESC social.connections |
Gets a description of the table. |
| USE | USE "http://myserver.com/mytables.xml" AS mytable;
|
Maps a table name to the the URL of an Open Data Table. |
| SET | SET (name)=(value);
|
Allows you to set up key values for use within Open Data Tables |