| author | František Kučera <franta-hg@frantovo.cz> |
| Tue, 14 Jul 2009 18:08:07 +0200 | |
| changeset 50 | 1eb68e2ac637 |
| parent 5 | 71c6de7f0a38 |
| 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> |