UPDATE

From SQLZoo
Jump to navigation Jump to search

UPDATE

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

games
yrcity
2000Sydney
2004Athens
2008Beijing
2012London

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

number
yrnumber
20001
20042
20083
20124
schema:scott
 DROP TABLE games
 CREATE TABLE games(
  yr INTEGER,
  city VARCHAR(20));
INSERT INTO games VALUES (2000,'Sydney');
INSERT INTO games VALUES (2004,'Athens');
INSERT INTO games VALUES (2008,'Beijing');
INSERT INTO games VALUES (2009,'London');
CREATE TABLE number(
  yr INTEGER,
  number VARCHAR(20));
INSERT INTO number VALUES (2000,'1');
INSERT INTO number VALUES (2004,'2');
INSERT INTO number VALUES (2008,'3');
INSERT INTO number VALUES (2009,'4');

The UPDATE statement can be used to change a values in rows that already exists. In this example we move the 2012 games from London to Paris.

UPDATE scott.games SET city='Paris' WHERE yr = 2012;
SELECT * FROM scott.games;
UPDATE games SET city='Paris' WHERE yr = 2012;
SELECT * FROM games;

See also

DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects