rendered paste bodymysql> describe Egzempliorius;
+-------------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------+------+-----+---------+-------+
| Nr | int(11) | | PRI | 0 | |
| ISBN | char(13) | | MUL | | |
| Skaitytojas | int(11) | YES | MUL | NULL | |
| Paimta | date | YES | | NULL | |
| Grazinti | date | YES | | NULL | |
+-------------+----------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> select * from Egzempliorius;
+-------+---------------+-------------+------------+------------+
| Nr | ISBN | Skaitytojas | Paimta | Grazinti |
+-------+---------------+-------------+------------+------------+
| 32101 | 9998-01-101-9 | NULL | NULL | NULL |
| 32102 | 9998-01-101-9 | NULL | NULL | NULL |
| 32103 | 9998-01-101-9 | NULL | NULL | NULL |
| 32104 | 9998-01-101-9 | 1000 | 2004-09-02 | 2004-10-05 |
| 32105 | 9998-01-101-9 | 1010 | 2004-09-14 | 2004-10-04 |
| 32106 | 9998-01-101-9 | 1021 | 2004-09-14 | 2004-10-04 |
| 32107 | 9998-01-101-9 | NULL | NULL | NULL |
| 32108 | 9998-01-101-9 | 1001 | 2004-09-02 | 2004-10-14 |
| 32109 | 9998-01-101-9 | 1032 | 2004-09-20 | 2004-10-05 |
| 32200 | 9998-01-102-7 | NULL | NULL | NULL |
| 32201 | 9998-01-102-7 | 1021 | 2004-09-02 | 2004-10-04 |
| 32301 | 9999-02-202-2 | 1000 | 2004-09-02 | 2004-09-15 |
| 32302 | 9999-02-202-2 | 1021 | 2004-09-14 | 2004-10-04 |
| 32303 | 9999-02-202-2 | NULL | NULL | NULL |
| 32330 | 9999-02-203-0 | NULL | NULL | NULL |
| 32331 | 9999-02-203-0 | NULL | NULL | NULL |
| 32332 | 9999-02-203-0 | 1010 | 2004-09-14 | 2004-10-05 |
| 32333 | 9999-02-203-0 | 1015 | 2004-09-14 | 2004-10-05 |
| 32401 | 9998-01-103-5 | NULL | NULL | NULL |
| 32402 | 9998-01-103-5 | 1032 | 2004-09-20 | 2004-10-05 |
| 32403 | 9998-01-103-5 | NULL | NULL | NULL |
| 32404 | 9998-01-103-5 | NULL | NULL | NULL |
| 32405 | 9998-01-103-5 | NULL | NULL | NULL |
| 32406 | 9998-01-103-5 | 1010 | 2004-09-14 | 2004-10-04 |
| 32501 | 9997-03-303-5 | 1010 | 2004-09-14 | 2004-10-04 |
| 32502 | 9997-03-303-5 | 1032 | 2004-09-20 | 2004-10-04 |
| 32503 | 9997-03-303-5 | 1015 | 2004-09-20 | 2004-10-05 |
| 32504 | 9997-03-303-5 | 1001 | 2004-09-06 | 2004-10-05 |
| 32601 | 9998-01-104-3 | NULL | NULL | NULL |
| 32602 | 9998-01-104-3 | NULL | NULL | NULL |
| 32603 | 9998-01-104-3 | NULL | NULL | NULL |
| 32604 | 9998-01-104-3 | NULL | NULL | NULL |
+-------+---------------+-------------+------------+------------+
32 rows in set (0.00 sec)