http://sqlzoo.net/w/index.php?title=Apostrophe&feed=atom&action=history
Apostrophe - Revision history
2013-05-18T14:01:17Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://sqlzoo.net/w/index.php?title=Apostrophe&diff=1064&oldid=prev
Marek at 13:12, 12 July 2012
2012-07-12T13:12:41Z
<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 13:12, 12 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 6:</td>
<td colspan="2" class="diff-lineno">Line 6:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang=sql class='tidy'></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang=sql class='tidy'></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang=sql class='setup'></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang=sql class='setup'></source></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle e-postgres e-mysql e-sqlserver'>SELECT * FROM <del class="diffchange diffchange-inline">cia</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle e-postgres e-mysql e-sqlserver'>SELECT * FROM <ins class="diffchange diffchange-inline">bbc</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>WHERE name = 'Cote d''Ivoire'</source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>WHERE name = 'Cote d''Ivoire'</source></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang='sql' class='def'>SELECT * FROM <del class="diffchange diffchange-inline">cia</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang='sql' class='def'>SELECT * FROM <ins class="diffchange diffchange-inline">bbc</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>WHERE name = 'Cote d''Ivoire'</source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>WHERE name = 'Cote d''Ivoire'</source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
</table>
Marek
http://sqlzoo.net/w/index.php?title=Apostrophe&diff=1063&oldid=prev
Marek at 13:10, 12 July 2012
2012-07-12T13:10: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 13:10, 12 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>How to build a statement on a word with an Apostrophe such as WHERE name='Tom's Book'</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>How to build a statement on a word with an Apostrophe such as WHERE name='Tom's Book'</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">scott</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">gisq</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></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><source lang=sql class='tidy'><del class="diffchange diffchange-inline">DROP TABLE cia;</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang=sql class='tidy'></source></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang=sql class='setup'></source></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang=sql class='setup'><del class="diffchange diffchange-inline">CREATE TABLE cia(name VARCHAR(10), region VARCHAR(10));</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'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">INSERT INTO cia VALUES ('Cote d''Ivoire', 'Africa');</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'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">INSERT INTO cia VALUES ('Japan', 'Asia');</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'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div></source></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'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle e-postgres e-mysql e-sqlserver'>SELECT * FROM cia</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle e-postgres e-mysql e-sqlserver'>SELECT * FROM cia</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>WHERE name = 'Cote d''Ivoire'</source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>WHERE name = 'Cote d''Ivoire'</source></div></td></tr>
</table>
Marek
http://sqlzoo.net/w/index.php?title=Apostrophe&diff=1023&oldid=prev
Marek at 11:22, 12 July 2012
2012-07-12T11:22:12Z
<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:22, 12 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>How to build a statement on a word with an Apostrophe such as WHERE name='Tom's Book'</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>How to build a statement on a word with an Apostrophe such as WHERE name='Tom's Book'</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 colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"><div class=params>schema:scott</div></ins></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></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><source lang=sql class='tidy'></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang=sql class='tidy'><ins class="diffchange diffchange-inline">DROP TABLE cia;</ins></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"></source></ins></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"><source lang=sql class='setup'>CREATE TABLE cia(name VARCHAR(10), region VARCHAR(10));</ins></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">INSERT INTO cia VALUES ('Cote d''Ivoire', 'Africa');</ins></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">INSERT INTO cia VALUES ('Japan', 'Asia');</ins></div></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><source lang='sql' class='def e-oracle e-postgres e-mysql e-sqlserver'>SELECT * FROM cia</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle e-postgres e-mysql e-sqlserver'>SELECT * FROM cia</div></td></tr>
</table>
Marek
http://sqlzoo.net/w/index.php?title=Apostrophe&diff=830&oldid=prev
Marek at 11:25, 11 July 2012
2012-07-11T11:25:47Z
<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:25, 11 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 6:</td>
<td colspan="2" class="diff-lineno">Line 6:</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><source lang='sql' class='def e-oracle e-postgres e-mysql e-sqlserver'>SELECT * FROM cia</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle e-postgres e-mysql e-sqlserver'>SELECT * FROM cia</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">WHERE name = 'Cote d''Ivoire'</source></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"><source lang='sql' class='def'>SELECT * FROM cia</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>WHERE name = 'Cote d''Ivoire'</source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>WHERE name = 'Cote d''Ivoire'</source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
</table>
Marek
http://sqlzoo.net/w/index.php?title=Apostrophe&diff=829&oldid=prev
Marek: Created page with "How to build a statement on a word with an Apostrophe such as WHERE name='Tom's Book' <div class='ht'> <div> </div> <source lang=sql class='tidy'> </source> <source lang='sql'..."
2012-07-11T11:24:01Z
<p>Created page with "How to build a statement on a word with an Apostrophe such as WHERE name='Tom's Book' <div class='ht'> <div> </div> <source lang=sql class='tidy'> </source> <source lang='sql'..."</p>
<p><b>New page</b></p><div>How to build a statement on a word with an Apostrophe such as WHERE name='Tom's Book'<br />
<div class='ht'><br />
<div><br />
</div><br />
<source lang=sql class='tidy'><br />
</source><br />
<source lang='sql' class='def e-oracle e-postgres e-mysql e-sqlserver'>SELECT * FROM cia<br />
WHERE name = 'Cote d''Ivoire'</source><br />
<br />
<div class="ecomm e-oracle" style="display: none">Use two apostrophes.</div><br />
<br />
</div><br />
{{SELECT Ref}}</div>
Marek