http://sqlzoo.net/w/index.php?title=CREATE_TABLE&feed=atom&action=history 2013-05-21T23:54:36Z Revision history for this page on the wiki MediaWiki 1.20.4 http://sqlzoo.net/w/index.php?title=CREATE_TABLE&diff=1465&oldid=prev 2012-07-17T11:35:52Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 11:35, 17 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 11:</td> <td colspan="2" class="diff-lineno">Line 11:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;div class=params&gt;schema:scott&lt;/div&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;div class=params&gt;schema:scott&lt;/div&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang=sql class='tidy'&gt; DROP TABLE games&lt;/source&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang=sql class='tidy'&gt; DROP TABLE games&lt;/source&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>The <del class="diffchange diffchange-inline">SELECT </del>statement <del class="diffchange diffchange-inline">returns results from a &lt;i&gt;</del>table<del class="diffchange diffchange-inline">&lt;/i&gt;. </del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>The <ins class="diffchange diffchange-inline">CREATE </ins>statement <ins class="diffchange diffchange-inline">builds an empty </ins>table <ins class="diffchange diffchange-inline">to hold </ins>rows.</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">With a WHERE clause only some </del>rows <del class="diffchange diffchange-inline">are returned</del>. &#160;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">In this </ins>example the <ins class="diffchange diffchange-inline">column yr is </ins>the <ins class="diffchange diffchange-inline">PRIMARY KEY: </ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">This </del>example <del class="diffchange diffchange-inline">shows </del>the <del class="diffchange diffchange-inline">year that Athens hosted </del>the <del class="diffchange diffchange-inline">Olympic games.</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang='sql' class='def e-oracle'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang='sql' class='def e-oracle'&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>CREATE TABLE games</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>CREATE TABLE games</div></td></tr> </table>

Connor http://sqlzoo.net/w/index.php?title=CREATE_TABLE&diff=1463&oldid=prev 2012-07-17T11:32:08Z

<p>Created page with &quot; &lt;h1&gt;CREATE TABLE&lt;/h1&gt; &lt;p&gt;The table &lt;code&gt;games&lt;/code&gt; shows the year and the city hosting the Olympic Games.&lt;/p&gt; &lt;table&gt; &lt;caption align=&#039;center&#039;&gt;games&lt;/caption&gt; &lt;tr&gt;&lt;th align...&quot;</p> <p><b>New page</b></p><div><br /> &lt;h1&gt;CREATE TABLE&lt;/h1&gt;<br /> &lt;p&gt;The table &lt;code&gt;games&lt;/code&gt; shows the year and the city hosting the Olympic Games.&lt;/p&gt;<br /> &lt;table&gt;<br /> &lt;caption align='center'&gt;games&lt;/caption&gt;<br /> &lt;tr&gt;&lt;th align='center'&gt;'''yr'''&lt;/th&gt;&lt;th align='center'&gt;'''city'''&lt;/th&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td&gt;2004&lt;/td&gt;&lt;td align='left'&gt;Athens&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td&gt;2008&lt;/td&gt;&lt;td align='left'&gt;Beijing&lt;/td&gt;&lt;/tr&gt;<br /> &lt;/table&gt;<br /> &lt;div class='ht'&gt;<br /> &lt;div class=params&gt;schema:scott&lt;/div&gt;<br /> &lt;source lang=sql class='tidy'&gt; DROP TABLE games&lt;/source&gt;<br /> The SELECT statement returns results from a &lt;i&gt;table&lt;/i&gt;. <br /> With a WHERE clause only some rows are returned. <br /> This example shows the year that Athens hosted the Olympic games.<br /> &lt;source lang='sql' class='def e-oracle'&gt;<br /> CREATE TABLE games<br /> (yr INT NOT NULL PRIMARY KEY<br /> ,city VARCHAR(20)<br /> );<br /> INSERT INTO games(yr,city) VALUES (2004,'Athens');<br /> INSERT INTO games(yr,city) VALUES (2008,'Beijing');<br /> SELECT * FROM games;<br /> &lt;/source&gt; <br /> &lt;source lang='sql' class='def'&gt;<br /> CREATE TABLE games<br /> (yr INT NOT NULL PRIMARY KEY<br /> ,city VARCHAR(20)<br /> );<br /> INSERT INTO games(yr,city) VALUES (2004,'Athens');<br /> INSERT INTO games(yr,city) VALUES (2008,'Beijing');<br /> SELECT * FROM games;<br /> &lt;/source&gt;<br /> &lt;/div&gt;<br /> <br /> &lt;p&gt;See also&lt;/p&gt;<br /> &lt;ul&gt;<br /> &lt;li&gt;[[INSERT_.._VALUES |INSERT]]&lt;/li&gt;<br /> &lt;li&gt;[[DROP |DROP]]&lt;/li&gt;<br /> &lt;/ul&gt;</div>

Connor