Ülesanne 5-Andmetabeli toomine varundusfailist-erinevad päringud
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 | |
+--------------+-------------+------+-----+---------+-------+
8 rows in set (0.00 sec)
4. Leia lapsed, kelle sünnikaal on väiksem võrdne 3800 grammist. Väljasta
nimi ja kaal.
mysql> SELECT L_nimi, Synnikaal FROM SYNNID WHERE Synnikaal<=3800;
annaabi.ee 
