"synnikuupaev" - 1 õppematerjal

Ülesanne 5-Andmetabeli toomine varundusfailist-erinevad päringud

| Ema_nimi | varchar(20) | YES | | NULL | | | Vanus | int(2) | YES | | NULL | | | Laste_arv | int(1) | YES | | NULL | | +-----------+-------------+------+-----+---------+-------+ 4 rows in set (0.00 sec) mysql> DESCRIBE SYNNID; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | Synnikuupaev | varchar(10) | YES | | NULL | | | Ema_id | int(2) | YES | MUL | NULL | | | L_nimi | varchar(9) | YES | | NULL | | | Elukoht | varchar(10) | YES | | NULL | | | Synniaeg | varchar(5) | YES | | NULL | | | Synnikaal | int(4) | YES | | NULL | | | Synnipikkus | int(2) | YES | | NULL | | | Sugu | varchar(1) | YES | | NULL | |