SELECT

From SQLZOO
Revision as of 20:18, 17 May 2012 by Andr3w (Talk | contribs)

Jump to: navigation, search
schema:scott

The table games shows the year and the city hosting the Olympic Games.

games
yr city
2000 Sydney
2004 Athens
2008 Beijing
2012 London

The SELECT statement returns results from a table. In this example the table is games and the columns are yr and city.

DROP TABLE games;

CREATE TABLE games(yr INT, city VARCHAR(20)); INSERT INTO games(city,yr) VALUES ('Sydney',2000); INSERT INTO games(city,yr) VALUES ('Athens',2004); INSERT INTO games(city,yr) VALUES ('Beijing',2008); INSERT INTO games(city,yr) VALUES ('London',2012);

SELECT yr, city FROM games

See also:

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense