| author | František Kučera <franta-hg@frantovo.cz> |
| Wed Dec 15 16:45:14 2010 +0100 (2010-12-15) | |
| changeset 75 | e0c23170f359 |
| parent 4 | 49903d1fe188 |
| permissions | -rw-r--r-- |
| franta-hg@5 | 1 |
<div> |
| franta-hg@5 | 2 |
<table> |
| franta-hg@5 | 3 |
<thead title="Chceš setřídit výsledek podle nějakého sloupce? Co takhle ORDER BY sloupec."> |
| franta-hg@5 | 4 |
<tr> |
| franta-hg@5 | 5 |
<td>Kdy</td> |
| franta-hg@5 | 6 |
<td>SQL příkaz</td> |
| franta-hg@5 | 7 |
</tr> |
| franta-hg@5 | 8 |
</thead> |
| franta-hg@5 | 9 |
<tbody> |
| franta-hg@5 | 10 |
<tr> |
| franta-hg@5 | 11 |
<td>2008-05-24 16:00:08</td> |
| franta-hg@5 | 12 |
<td>SELECT * FROM tabulka WHERE id = 123;</td> |
| franta-hg@5 | 13 |
</tr> |
| franta-hg@5 | 14 |
<tr> |
| franta-hg@5 | 15 |
<td>2008-05-24 15:55:10</td> |
| franta-hg@5 | 16 |
<td>SELECT * FROM tabulka WHERE id = 123 ORDER BY datum DESC;</td> |
| franta-hg@5 | 17 |
</tr> |
| franta-hg@5 | 18 |
<tr> |
| franta-hg@5 | 19 |
<td>2008-05-24 15:51:28</td> |
| franta-hg@5 | 20 |
<td>SELECT * <br/>FROM tabulka <br/>JOIN druha_tabulka USING (email) <br/>WHERE id = 8;</td> |
| franta-hg@5 | 21 |
</tr> |
| franta-hg@5 | 22 |
</tbody> |
| franta-hg@5 | 23 |
</table> |
| franta-hg@5 | 24 |
<p class="vysledekOK">Toto je historie provedených SQL příkazů.</p> |
| franta-hg@5 | 25 |
<p class="vysledekTip">„Nějaký pěkný tip, citát, nebo <a href="http://frantovo.cz/blog/">odkaz</a> na stránku.“</p> |
| franta-hg@5 | 26 |
</div> |