Difference between revisions of "CREATE TABLE"
|(One intermediate revision by one other user not shown)|
Revision as of 12:34, 9 March 2014
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;