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;

SELECT * FROM mytable WHERE...

Maps a table name to the URL of an Open Data Table.
SET SET (name)=(value);

SELECT * FROM mytable WHERE...

Allows you to set up key values for use within Open Data Tables

Table of Contents