Difference between revisions of "UPDATE"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
</table> | </table> | ||
| + | <table class='NoBorder'><td><tr> | ||
| + | The table <code>games</code> shows the year and the city hosting the Olympic Games. | ||
| + | </td><td> | ||
| + | <table style='float:left' class='Bordered'> | ||
| + | <caption align='center'>'''games'''</caption> | ||
| + | <tr><th align='center'>'''yr'''</th><th align='center'>'''city'''</th></tr> | ||
| + | <tr><td>2000</td><td align='left'>Sydney</td></tr> | ||
| + | <tr><td>2004</td><td align='left'>Athens</td></tr> | ||
| + | <tr><td>2008</td><td align='left'>Beijing</td></tr> | ||
| + | <tr><td>2012</td><td align='left'>London</td></tr> | ||
| + | </table> | ||
| + | </table> | ||
| + | |||
<div class='ht'> | <div class='ht'> | ||
<div class=params>schema:scott</div> | <div class=params>schema:scott</div> | ||
Revision as of 14:36, 6 May 2014
UPDATE
The table games shows the year and the city hosting the Olympic Games.
|
The table games 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');
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
