mysql> describe kodanikud;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| eesnimi  | varchar(15) | YES  |     | NULL    |       |
| perenimi | varchar(15) | YES  |     | NULL    |       |
| syndinud | date        | YES  |     | NULL    |       |
| sugu     | char(1)     | YES  |     | NULL    |       |
| pkseis   | varchar(9)  | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> select * from kodanikud;
+---------+----------+------------+------+-----------+
| eesnimi | perenimi | syndinud   | sugu | pkseis    |
+---------+----------+------------+------+-----------+
| Tanel   | Toova    | 1983-08-12 | M    | vallaline |
| Jaan    | Juur     | 1981-01-02 | M    | abielus   |
| Mari    | Maasikas | 1980-08-11 | N    | vallaline |
| Peeter  | Pohl     | 1970-08-11 | M    | abielus   |
| Juhan   | Juurikas | 1987-04-12 | M    | abielus   |
| Milli   | Mallikas | 1978-11-21 | N    | vallaline |
| Maalik  | Kunstnik | 1945-05-22 | N    | vallaline |
| Peeter  | Pihlakas | 1982-08-10 | M    | vallaline |
| Nelli   | Naeris   | 1978-12-03 | N    | abielus   |
| kfjsd   | dkfjdsfl | 1982-01-10 | N    | abielus   |
+---------+----------+------------+------+-----------+
10 rows in set (0.00 sec)

mysql>
NB! SQL.html töötab korralikult ainult exploreriga ja (sorry!).