Revision as of 10:42, 7 March 2014 by 22.214.171.124
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 table1 (id INT PRIMARY KEY,name VARCHAR(20),city VARCHAR(20),mobile NUMERIC(10,0) );