Bazalar kodlari Nurshodbek, [11/9/2023 1: 38 am] mysql> create database masulyatni taqsimlash

Bazalar kodlari 
Nurshodbek, [11/9/2023 1:38 AM] 
mysql> create database masulyatni_taqsimlash; 
Query OK, 1 row affected (0.00 sec) 
mysql> show databases; 
+-----------------------+ 
| Database | 
+-----------------------+ 
| information_schema | 
| idora | 
| kutubxona | 
| lombard | 
| masulyatni_taqsimlash | 
| mysql | 
| sayohat_kompaniyasi | 
| test | 
+-----------------------+ 
8 rows in set (0.00 sec) 
mysql> use masulyatni_taqsimlash; 
Database changed 
mysql> create table xodimlar( 
-> id int auto_increment primary key, 
-> familyasi varchar(100), 
-> ismi varchar(100), 
-> otasining_ismi varchar(100), 
-> ish_haqi int); 
Query OK, 0 rows affected (0.02 sec) 

mysql> create table ish_turlari( 
-> id int auto_increment primary key, 
-> tavsif text, 
-> kuniga_tolov varchar(100)); 
Query OK, 0 rows affected (0.01 sec) 
Nurshodbek, [11/9/2023 1:38 AM] 
mysql> INSERT INTO xodimlar (familyasi, ismi, otasining_ismi, ish_haqi) 
-> VALUES ('Smith', 'John', 'Michael', 50000); 
Query OK, 1 row affected (0.00 sec) 
mysql> INSERT INTO ish_turlari (tavsif, kuniga_tolov) 
-> VALUES ('Job description for type A', 'Monthly'); 
Query OK, 1 row affected (0.00 sec) 
mysql> INSERT INTO ish (boshlanish_sanasi, tugash_sanasi, ish_turlari_id) 
-> VALUES ('2023-11-09', '2023-11-15', 1); 
Query OK, 1 row affected (0.00 sec) 
mysql> select*from xodimlar; 
+----+-----------+------+----------------+----------+ 
| id | familyasi | ismi | otasining_ismi | ish_haqi | 
+----+-----------+------+----------------+----------+ 
| 1 | Smith | John | Michael | 50000 | 
+----+-----------+------+----------------+----------+ 
1 row in set (0.00 sec) 
mysql> select*from ish_turlari; 

+----+----------------------------+--------------+ 
| id | tavsif | kuniga_tolov | 
+----+----------------------------+--------------+ 
| 1 | Job description for type A | Monthly | 
+----+----------------------------+--------------+ 
1 row in set (0.00 sec) 
mysql> select*from ish; 
+----+-------------------+---------------+----------------+ 
| id | boshlanish_sanasi | tugash_sanasi | ish_turlari_id | 
+----+-------------------+---------------+----------------+ 
| 1 | 2023-11-09 | 2023-11-15 | 1 | 
+----+-------------------+---------------+----------------+ 
1 row in set (0.00 sec) 
Nurshodbek, [11/9/2023 1:38 AM] 
mysql> create table ish( 
-> id int auto_increment primary key, 
-> boshlanish_sanasi date, 
-> tugash_sanasi date); 
Query OK, 0 rows affected (0.01 sec) 
mysql> alter table ish 
-> add column ish_turlari_id int, 
-> add foreign key (ish_turlari_id) references ish_turlari(id); 
Query OK, 0 rows affected (0.02 sec) 
Records: 0 Duplicates: 0 Warnings: 0 
mysql> show tables; 

+---------------------------------+ 
| Tables_in_masulyatni_taqsimlash | 
+---------------------------------+ 
| ish | 
| ish_turlari | 
| xodimlar | 
+---------------------------------+ 
3 rows in set (0.00 sec) 
mysql> desc ish; 
+-------------------+---------+------+-----+---------+----------------+ 
| Field | Type | Null | Key | Default | Extra | 
+-------------------+---------+------+-----+---------+----------------+ 
| id | int(11) | NO | PRI | NULL | auto_increment | 
| boshlanish_sanasi | date | YES | | NULL | | 
| tugash_sanasi | date | YES | | NULL | | 
| ish_turlari_id | int(11) | YES | MUL | NULL | | 
+-------------------+---------+------+-----+---------+----------------+ 
4 rows in set (0.01 sec) 
mysql> desc xodimlar; 
+----------------+--------------+------+-----+---------+----------------+ 
| Field | Type | Null | Key | Default | Extra | 
+----------------+--------------+------+-----+---------+----------------+ 
| id | int(11) | NO | PRI | NULL | auto_increment | 
| familyasi | varchar(100) | YES | | NULL | | 
| ismi | varchar(100) | YES | | NULL | | 
| otasining_ismi | varchar(100) | YES | | NULL | | 
| ish_haqi | int(11) | YES | | NULL | | 

+----------------+--------------+------+-----+---------+----------------+ 
5 rows in set (0.01 sec) 
mysql> desc ish_turlari; 
+--------------+--------------+------+-----+---------+----------------+ 
| Field | Type | Null | Key | Default | Extra | 
+--------------+--------------+------+-----+---------+----------------+ 
| id | int(11) | NO | PRI | NULL | auto_increment | 
| tavsif | text | YES | | NULL | | 
| kuniga_tolov | varchar(100) | YES | | NULL | | 
+--------------+--------------+------+-----+---------+----------------+ 
3 rows in set (0.01 sec)