All pastes #548762 Raw Edit

Stuff

public text v1 · immutable
·published 2007-06-07 21:04 UTC
rendered paste body
mysql> 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)