Text formatted with Texy:
Databáze menagerie
Struktura tabulky event
Sloupec |
Typ |
Nulový |
Výchozí |
name |
varchar(20) |
Ano |
NULL |
date |
date |
Ano |
NULL |
type |
varchar(15) |
Ano |
NULL |
remark |
varchar(255) |
Ano |
NULL |
Vypisuji data pro tabulku
event
name |
date |
type |
remark |
Fluffy |
1995–05–15 |
litter |
4 kittens, 3 female, 1 male |
Buffy |
1993–06–23 |
litter |
5 puppies, 2 female, 3 male |
Buffy |
1994–06–19 |
litter |
3 puppies, 3 female |
Chirpy |
1999–03–21 |
vet |
needed beak straightened |
Slim |
1997–08–03 |
vet |
broken rib |
Bowser |
1991–10–12 |
kennel |
|
Fang |
1991–10–12 |
kennel |
|
Fang |
1998–08–28 |
birthday |
Gave him a new chew toy |
Claws |
1998–03–17 |
birthday |
Gave him a new flea collar |
Whistler |
1998–12–09 |
birthday |
First birthday |
Struktura tabulky pet
Sloupec |
Typ |
Nulový |
Výchozí |
name |
varchar(20) |
Ano |
NULL |
owner |
varchar(20) |
Ano |
NULL |
species |
varchar(20) |
Ano |
NULL |
sex |
char(1) |
Ano |
NULL |
birth |
date |
Ano |
NULL |
death |
date |
Ano |
NULL |
Vypisuji data pro tabulku pet
name |
owner |
species |
sex |
birth |
death |
Fluffy |
Harold |
cat |
f |
1993–02–04 |
|
Claws |
Gwen |
cat |
m |
1994–03–17 |
|
Buffy |
Harold |
dog |
f |
1989–05–13 |
|
Fang |
Benny |
dog |
m |
1990–08–27 |
|
Bowser |
Diane |
dog |
m |
1979–08–31 |
1995–07–29 |
Chirpy |
Gwen |
bird |
f |
1998–09–11 |
|
Whistler |
Gwen |
bird |
1997–12–09 |
|
Slim |
Benny |
snake |
m |
1996–04–29 |
|
Puffball |
Diane |
hamster |
f |
1999–03–30 |
|
Generated HTML code:
<h1 id="toc-databaze-menagerie">Databáze menagerie</h1>
<h2 id="toc-struktura-tabulky-event">Struktura tabulky event</h2>
<table>
<thead>
<tr>
<th>Sloupec</th>
<th>Typ</th>
<th>Nulový</th>
<th>Výchozí</th>
</tr>
</thead>
<tbody>
<tr>
<td>name</td>
<td>varchar(20)</td>
<td>Ano</td>
<td>NULL</td>
</tr>
<tr>
<td>date</td>
<td>date</td>
<td>Ano</td>
<td>NULL</td>
</tr>
<tr>
<td>type</td>
<td>varchar(15)</td>
<td>Ano</td>
<td>NULL</td>
</tr>
<tr>
<td>remark</td>
<td>varchar(255)</td>
<td>Ano</td>
<td>NULL</td>
</tr>
</tbody>
</table>
<h2 id="toc-vypisuji-data-pro-tabulku-event">Vypisuji data pro tabulku
event</h2>
<table>
<thead>
<tr>
<th>name</th>
<th>date</th>
<th>type</th>
<th>remark</th>
</tr>
</thead>
<tbody>
<tr>
<td>Fluffy</td>
<td>1995–05–15</td>
<td>litter</td>
<td>4 kittens, 3 female, 1 male</td>
</tr>
<tr>
<td>Buffy</td>
<td>1993–06–23</td>
<td>litter</td>
<td>5 puppies, 2 female, 3 male</td>
</tr>
<tr>
<td>Buffy</td>
<td>1994–06–19</td>
<td>litter</td>
<td>3 puppies, 3 female</td>
</tr>
<tr>
<td>Chirpy</td>
<td>1999–03–21</td>
<td>vet</td>
<td>needed beak straightened</td>
</tr>
<tr>
<td>Slim</td>
<td>1997–08–03</td>
<td>vet</td>
<td>broken rib</td>
</tr>
<tr>
<td>Bowser</td>
<td>1991–10–12</td>
<td>kennel</td>
<td> </td>
</tr>
<tr>
<td>Fang</td>
<td>1991–10–12</td>
<td>kennel</td>
<td> </td>
</tr>
<tr>
<td>Fang</td>
<td>1998–08–28</td>
<td>birthday</td>
<td>Gave him a new chew toy</td>
</tr>
<tr>
<td>Claws</td>
<td>1998–03–17</td>
<td>birthday</td>
<td>Gave him a new flea collar</td>
</tr>
<tr>
<td>Whistler</td>
<td>1998–12–09</td>
<td>birthday</td>
<td>First birthday</td>
</tr>
</tbody>
</table>
<h2 id="toc-struktura-tabulky-pet">Struktura tabulky pet</h2>
<table>
<thead>
<tr>
<th>Sloupec</th>
<th>Typ</th>
<th>Nulový</th>
<th>Výchozí</th>
</tr>
</thead>
<tbody>
<tr>
<td>name</td>
<td>varchar(20)</td>
<td>Ano</td>
<td>NULL</td>
</tr>
<tr>
<td>owner</td>
<td>varchar(20)</td>
<td>Ano</td>
<td>NULL</td>
</tr>
<tr>
<td>species</td>
<td>varchar(20)</td>
<td>Ano</td>
<td>NULL</td>
</tr>
<tr>
<td>sex</td>
<td>char(1)</td>
<td>Ano</td>
<td>NULL</td>
</tr>
<tr>
<td>birth</td>
<td>date</td>
<td>Ano</td>
<td>NULL</td>
</tr>
<tr>
<td>death</td>
<td>date</td>
<td>Ano</td>
<td>NULL</td>
</tr>
</tbody>
</table>
<h2 id="toc-vypisuji-data-pro-tabulku-pet">Vypisuji data pro tabulku pet</h2>
<table>
<thead>
<tr>
<th>name</th>
<th>owner</th>
<th>species</th>
<th>sex</th>
<th>birth</th>
<th>death</th>
</tr>
</thead>
<tbody>
<tr>
<td>Fluffy</td>
<td>Harold</td>
<td>cat</td>
<td>f</td>
<td>1993–02–04</td>
<td> </td>
</tr>
<tr>
<td>Claws</td>
<td>Gwen</td>
<td>cat</td>
<td>m</td>
<td>1994–03–17</td>
<td> </td>
</tr>
<tr>
<td>Buffy</td>
<td>Harold</td>
<td>dog</td>
<td>f</td>
<td>1989–05–13</td>
<td> </td>
</tr>
<tr>
<td>Fang</td>
<td>Benny</td>
<td>dog</td>
<td>m</td>
<td>1990–08–27</td>
<td> </td>
</tr>
<tr>
<td>Bowser</td>
<td>Diane</td>
<td>dog</td>
<td>m</td>
<td>1979–08–31</td>
<td>1995–07–29</td>
</tr>
<tr>
<td>Chirpy</td>
<td>Gwen</td>
<td>bird</td>
<td>f</td>
<td>1998–09–11</td>
<td> </td>
</tr>
<tr>
<td>Whistler</td>
<td>Gwen</td>
<td colspan="2">bird</td>
<td>1997–12–09</td>
<td> </td>
</tr>
<tr>
<td>Slim</td>
<td>Benny</td>
<td>snake</td>
<td>m</td>
<td>1996–04–29</td>
<td> </td>
</tr>
<tr>
<td>Puffball</td>
<td>Diane</td>
<td>hamster</td>
<td>f</td>
<td>1999–03–30</td>
<td> </td>
</tr>
</tbody>
</table>
Verze Texy: 3.2.2 (konfigurace)