Difference between revisions of "UPDATE"
Jump to navigation
Jump to search
| (4 intermediate revisions by the same user not shown) | |||
| Line 15: | Line 15: | ||
<table class='NoBorder'><td><tr> | <table class='NoBorder'><td><tr> | ||
| − | The table <code> | + | The table <code>number</code> shows the year and the city hosting the Olympic Games. |
</td><td> | </td><td> | ||
<table style='float:left' class='Bordered'> | <table style='float:left' class='Bordered'> | ||
| − | <caption align='center'>''' | + | <caption align='center'>'''number'''</caption> |
| − | <tr><th align='center'>'''yr'''</th><th align='center'>''' | + | <tr><th align='center'>'''yr'''</th><th align='center'>'''number'''</th></tr> |
| − | <tr><td>2000</td><td align='left'> | + | <tr><td>2000</td><td align='left'>1</td></tr> |
| − | <tr><td>2004</td><td align='left'> | + | <tr><td>2004</td><td align='left'>2</td></tr> |
| − | <tr><td>2008</td><td align='left'> | + | <tr><td>2008</td><td align='left'>3</td></tr> |
| − | <tr><td>2012</td><td align='left'> | + | <tr><td>2012</td><td align='left'>4</td></tr> |
</table> | </table> | ||
</table> | </table> | ||
| Line 37: | Line 37: | ||
INSERT INTO games VALUES (2008,'Beijing'); | INSERT INTO games VALUES (2008,'Beijing'); | ||
INSERT INTO games VALUES (2009,'London'); | INSERT INTO games VALUES (2009,'London'); | ||
| + | </source> | ||
| + | |||
| + | <source lang=sql class='setup'> | ||
| + | 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'); | ||
| + | |||
| + | |||
</source> | </source> | ||
The UPDATE statement can be used to change a values in rows that already exists. | The UPDATE statement can be used to change a values in rows that already exists. | ||
Latest revision as of 14:42, 6 May 2014
UPDATE
The table games shows the year and the city hosting the Olympic Games.
|
The table number shows the year and the city hosting the Olympic Games.
|
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
