ALTER - Revision history

Andr3w: Undo revision 13160 by 180.211.64.153 (talk)

2013-05-09T14:22:09Z

Undo revision 13160 by 180.211.64.153 (talk)

180.211.64.153 at 06:39, 9 May 2013

2013-05-09T06:39:34Z

Peter at 15:57, 8 September 2012

2012-09-08T15:57:48Z

Connor: Created page with "

ALTER TABLE

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

games
2012-07-17T12:28:49Z Created page with " <h1>ALTER TABLE</h1> <p>The table <code>games</code> shows the year and the city hosting the Olympic Games.</p> <table> <caption align='center'>games</caption> <tr><th align=..." New page <h1>ALTER TABLE</h1> <p>The table <code>games</code> shows the year and the city hosting the Olympic Games.</p> <table> <caption align='center'>games</caption> <tr><th align='center'>'''yr'''</th><th align='center'>'''city'''</th></tr> <tr><td>2004</td><td align='left'>Athens</td></tr> <tr><td>2006</td><td align='left'>Turin</td></tr> </table> <div class='ht'> <div class=params>schema:scott</div> <source lang=sql class='tidy'> DROP TABLE games</source> <source lang=sql class='setup'> CREATE TABLE games( yr INTEGER PRIMARY KEY, city VARCHAR(20)); INSERT INTO games VALUES (2004,'Athens'); INSERT INTO games VALUES (2006,'Turin'); </source> The ALTER statement can be used to add a column. In this example the column season indicates if the games are winter or summer games. <source lang='sql' class='def e-oracle'> SELECT * FROM scott.games; ALTER TABLE games ADD season VARCHAR(6); UPDATE games SET season = 'summer' WHERE yr = 2004; UPDATE games SET season = 'winter' WHERE yr = 2006; SELECT * FROM scott.games; </source> <source lang='sql' class='def'> SELECT * FROM games; ALTER TABLE games ADD season VARCHAR(6); UPDATE games SET season = 'summer' WHERE yr = 2004; UPDATE games SET season = 'winter' WHERE yr = 2006; SELECT * FROM games; </source> </div> <p>See also</p> <ul> <li>[[INSERT_.._VALUES \|INSERT]]</li> <li>[[DROP \|DROP]]</li> </ul>

← Older revision		Revision as of 15:57, 8 September 2012
Line 45:		Line 45:
	<li>[[DROP \|DROP]]</li>		<li>[[DROP \|DROP]]</li>
	</ul>		</ul>
		+
		+	{{Languages}}

@@ Line 1: / Line 1: @@
-[[File:C:\Users\mn33894\Desktop\Subbu.jpeg]]
 <h1>ALTER TABLE</h1>
 <p>The table <code>games</code> shows the year and the city hosting the Olympic Games.</p>