http://sqlzoo.net/w/index.php?title=CREATE_a_new_table&feed=atom&action=history
CREATE a new table - Revision history
2013-05-21T13:49:28Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://sqlzoo.net/w/index.php?title=CREATE_a_new_table&diff=1267&oldid=prev
Connor at 09:42, 16 July 2012
2012-07-16T09:42:38Z
<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 09:42, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>CREATE a new table</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>CREATE a new table</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='ht'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='ht'></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><div class=params>schema:<del class="diffchange diffchange-inline">gisq</del></div></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><div class=params>schema:<ins class="diffchange diffchange-inline">scott</ins></div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The following are examples of field types:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The following are examples of field types:</div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=CREATE_a_new_table&diff=1100&oldid=prev
Marek at 14:50, 12 July 2012
2012-07-12T14:50:48Z
<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 14:50, 12 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 31:</td>
<td colspan="2" class="diff-lineno">Line 31:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>{{<del class="diffchange diffchange-inline">SELECT Ref</del>}}</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>{{<ins class="diffchange diffchange-inline">CREATE and DROP ref</ins>}}</div></td></tr>
</table>
Marek
http://sqlzoo.net/w/index.php?title=CREATE_a_new_table&diff=1099&oldid=prev
Marek at 14:50, 12 July 2012
2012-07-12T14:50:03Z
<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 14:50, 12 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 21:</td>
<td colspan="2" class="diff-lineno">Line 21:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  ,b VARCHAR(10)</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  ,b VARCHAR(10)</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  )</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  )</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class="ecomm e-access" style="display: none"></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class="ecomm e-access" style="display: none"></div></td></tr>
</table>
Marek
http://sqlzoo.net/w/index.php?title=CREATE_a_new_table&diff=1097&oldid=prev
Marek: Created page with "CREATE a new table <div class='ht'> <div class=params>schema:gisq</div> <div> The following are examples of field types: <table><tr><td>INTEGER</td><td>A whole number</td></t..."
2012-07-12T14:46:33Z
<p>Created page with "CREATE a new table <div class='ht'> <div class=params>schema:gisq</div> <div> The following are examples of field types: <table><tr><td>INTEGER</td><td>A whole number</td></t..."</p>
<p><b>New page</b></p><div>CREATE a new table<br />
<div class='ht'><br />
<div class=params>schema:gisq</div><br />
<div><br />
The following are examples of field types:<br />
<table><tr><td>INTEGER</td><td>A whole number</td></tr><tr><td>VARCHAR(10)</td><td>Up to 10 characters.</td></tr><tr><td>CHAR(10)</td><td>Fixed number of characters</td></tr><tr><td>DATE</td><td>A date</td></tr><tr><td>TIMESTAMP</td><td>Date and time</td></tr><tr><td>FLOAT</td><td>Floating point numbers</td></tr></table><br />
</div><br />
<source lang=sql class='tidy'>DROP TABLE t_test</source><br />
<source lang=sql class='setup'></source><br />
<source lang='sql' class='def e-db2'>CREATE TABLE t_test<br />
(a INTEGER NOT NULL PRIMARY KEY<br />
,b VARCHAR(10)<br />
)<br />
</source><br />
<source lang='sql' class='def e-oracle'>CREATE TABLE t_test<br />
(a INTEGER PRIMARY KEY<br />
,b VARCHAR2(10)<br />
)</source><br />
<source lang='sql' class='def'>CREATE TABLE t_test<br />
(a INTEGER PRIMARY KEY<br />
,b VARCHAR(10)<br />
)<br />
<br />
</source><br />
<div class="ecomm e-access" style="display: none"><br />
<table><tr><td>MEMO</td><td>Allows up to 65535 characters</td></tr><tr><td>CURRENCY</td><td>Suitable for money.</td></tr></table><br />
</div><br />
<div class="ecomm e-sqlserver" style="display: none">The DATE type is not supported. Use DATETIME instead.</div><br />
<div class="ecomm e-oracle" style="display: none"><table><tr><td>CLOB</td><td>Allows large character fields.</td></tr><tr><td>NUMBER(10,2)</td><td>Up to 10 digits before the point, 2 after.</td></tr></table></div><br />
<div class="ecomm e-mysql" style="display: none"><br />
<table><tr><td>TEXT</td><td>Allows up to 65535 characters</td></tr><tr><td>DECIMAL(10,2)</td><td>Up to 10 digits before the point, 2 after.</td></tr></table><br />
</div><br />
</div><br />
{{SELECT Ref}}</div>
Marek