MySQL!

[DeadSilence]

mysql> show tables;
+----------------------+
| Tables_in_firma10vn9 |
+----------------------+
| dlujnosti |
| slujiteli |
| trudovstaj |
+----------------------+
3 rows in set (0.03 sec)

mysql> show columns from slujiteli;
+-----------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------------+------+-----+---------+-------+
| id | int(10) unsigned | NO | PRI | NULL | |
| ime | varchar(50) | YES | | NULL | |
| mestorojdenie | varchar(20) | YES | | NULL | |
| Data | date | YES | | NULL | |
| zaemanadlajnost | int(10) unsigned | YES | | NULL | |
+-----------------+------------------+------+-----+---------+-------+
5 rows in set (0.02 sec)

mysql> show columns from dlujnosti;
+---------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+-------+
| kodnadlajnost | int(10) unsigned | NO | PRI | NULL | |
| dlajnost | varchar(50) | YES | | NULL | |
| minimalenprag | int(10) unsigned | YES | | NULL | |
+---------------+------------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

mysql> show columns from trudovstaj;
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| ID | int(10) unsigned | NO | PRI | NULL | |
| zaplata | float unsigned | YES | | NULL | |
| trudovstaj | int(10) unsigned | YES | | NULL | |
+------------+------------------+------+-----+---------+-------+
3 rows in set (0.03 sec)

mysql> select * from dlujnosti;
+---------------+-----------+---------------+
| kodnadlajnost | dlajnost | minimalenprag |
+---------------+-----------+---------------+
| 1 | Servitior | 200 |
| 2 | barman | 200 |
| 3 | gotvach | 300 |
| 4 | opravitel | 500 |
| 5 | chistach | 150 |
+---------------+-----------+---------------+
5 rows in set (0.01 sec)

mysql> select * from slujiteli;
+----+--------------------+---------------+------------+-----------------+
| id | ime | mestorojdenie | Data | zaemanadlajnost |
+----+--------------------+---------------+------------+-----------------+
| 1 | Kalina Valcheva | Sofia | 2011-05-10 | 1 |
| 2 | Ralica ivanova | Smolqn | 2010-10-10 | 1 |
| 3 | Sonq Dancheva | Varna | 2010-09-07 | 2 |
| 4 | ivailo bozinarev | Smolqn | 2011-08-15 | 2 |
| 5 | Iskra Karamucheva | Plovdiv | 2010-05-10 | 4 |
| 6 | Teodora Sharovska | Plovdiv | 2010-06-20 | 3 |
| 7 | Dimitar Uzunov | Smolqn | 2011-04-18 | 3 |
| 8 | Antoaneta Dushkova | Sofiq | 2010-05-10 | 5 |
| 9 | Tanq Kostova | Smolqn | 2011-05-10 | 5 |
| 10 | Stoqnka Ahilova | Smolqn | 2010-05-10 | 5 |
+----+--------------------+---------------+------------+-----------------+
10 rows in set (0.00 sec)

mysql>

[dimitar_ak]

Схващаш ли?