is valid?       need help?

Text zformátovaný pomocí 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  

Vygenerovaný HTML kód:

<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&ndash;05&ndash;15</td>

            <td>litter</td>

            <td>4&nbsp;kittens, 3&nbsp;female, 1&nbsp;male</td>
        </tr>

        <tr>
            <td>Buffy</td>

            <td>1993&ndash;06&ndash;23</td>

            <td>litter</td>

            <td>5&nbsp;puppies, 2&nbsp;female, 3&nbsp;male</td>
        </tr>

        <tr>
            <td>Buffy</td>

            <td>1994&ndash;06&ndash;19</td>

            <td>litter</td>

            <td>3&nbsp;puppies, 3&nbsp;female</td>
        </tr>

        <tr>
            <td>Chirpy</td>

            <td>1999&ndash;03&ndash;21</td>

            <td>vet</td>

            <td>needed beak straightened</td>
        </tr>

        <tr>
            <td>Slim</td>

            <td>1997&ndash;08&ndash;03</td>

            <td>vet</td>

            <td>broken rib</td>
        </tr>

        <tr>
            <td>Bowser</td>

            <td>1991&ndash;10&ndash;12</td>

            <td>kennel</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>Fang</td>

            <td>1991&ndash;10&ndash;12</td>

            <td>kennel</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>Fang</td>

            <td>1998&ndash;08&ndash;28</td>

            <td>birthday</td>

            <td>Gave him a new chew toy</td>
        </tr>

        <tr>
            <td>Claws</td>

            <td>1998&ndash;03&ndash;17</td>

            <td>birthday</td>

            <td>Gave him a new flea collar</td>
        </tr>

        <tr>
            <td>Whistler</td>

            <td>1998&ndash;12&ndash;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&ndash;02&ndash;04</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>Claws</td>

            <td>Gwen</td>

            <td>cat</td>

            <td>m</td>

            <td>1994&ndash;03&ndash;17</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>Buffy</td>

            <td>Harold</td>

            <td>dog</td>

            <td>f</td>

            <td>1989&ndash;05&ndash;13</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>Fang</td>

            <td>Benny</td>

            <td>dog</td>

            <td>m</td>

            <td>1990&ndash;08&ndash;27</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>Bowser</td>

            <td>Diane</td>

            <td>dog</td>

            <td>m</td>

            <td>1979&ndash;08&ndash;31</td>

            <td>1995&ndash;07&ndash;29</td>
        </tr>

        <tr>
            <td>Chirpy</td>

            <td>Gwen</td>

            <td>bird</td>

            <td>f</td>

            <td>1998&ndash;09&ndash;11</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>Whistler</td>

            <td>Gwen</td>

            <td colspan="2">bird</td>

            <td>1997&ndash;12&ndash;09</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>Slim</td>

            <td>Benny</td>

            <td>snake</td>

            <td>m</td>

            <td>1996&ndash;04&ndash;29</td>

            <td>&nbsp;</td>
        </tr>

        <tr>
            <td>Puffball</td>

            <td>Diane</td>

            <td>hamster</td>

            <td>f</td>

            <td>1999&ndash;03&ndash;30</td>

            <td>&nbsp;</td>
        </tr>
    </tbody>
</table>
Verze Texy: 3.0-dev (konfigurace)