Revision as of 12:34, 9 March 2014 by Andr3w (Reverted edits by 220.127.116.11 (talk) to last revision by Andr3w)
games shows the year and the city hosting the Olympic Games.
DROP TABLE games
The CREATE statement builds an empty table to hold rows. In this example the column yr is the PRIMARY KEY:
CREATE TABLE games (yr INT NOT NULL PRIMARY KEY ,city VARCHAR(20) ); INSERT INTO games(yr,city) VALUES (2004,'Athens'); INSERT INTO games(yr,city) VALUES (2008,'Beijing'); SELECT * FROM games;