Mumkin kadar malakali aniqlay bilsin. Amaliy programmalarning butunligini saqlab kolish shartida qanday o`zgarishlarni kiritish еtarlidir


Download 0.59 Mb.
Pdf ko'rish
bet3/4
Sana20.12.2022
Hajmi0.59 Mb.
#1036271
1   2   3   4
Bog'liq
MYSQL

Insert into Buyrug’i 
mysql> insert into bolimlar 
-> values(1,'Qabul qilish',1,5), 
-> (2,'Yukchilar',2,5), 
-> (3,'Qadoqli sut',3,5), 
-> (4,'Smetana',4,5), 
-> (5,'pishloq',5,5); 
Query OK, 5 rows affected (0.07 sec) 
Records: 5 Duplicates: 0 Warnings: 0 
mysql> insert into hodimlar 
-> values(2,'Ilhomjon','Latifov','Qoqon shahar Oltinkol 5-uy','1988-05-22',2,'Bolim 
boshligi','3560.000'), 
-> (3,'Jahongir','Turgunov','Yangiqorgon tumani Tillatepa 56-uy','1998-04-26',3,'Bolim 
boshligi','3700.000'), 
-> (4,'Nuriddin','Ergashev','Yangiqorgon tumani Meshon 40-uy','1997-11-22',4,'Bolim 
boshligi','3900.000'), 
-> (5,'Murodjon','Shokarimov','Chust tumani Tatar 99-uy','2001-11-07',5,'Bolim 
boshligi','3800.000'); 
mysql> select nomi,boshligi,manzili,xodim,hajmi,sanasi from yetkazuvchilar; 
Query OK, 4 rows affected (0.04 sec) 
Records: 4 Duplicates: 0 Warnings: 0 
mysql> insert into Mahsulotlar 
-> values(1,'Qadoqli sut','litr','Mega Savdo MCHJ',3,'2022-11-11','3 oy','4500'), 
-> (2,'Smetana','Kilogram','BossMilk MCHJ',4,'2022-10-11','2 oy','8500'), 
-> (3,'Pishloq','Kilogram','ExpresMilk MCHJ',5,'2022-11-10','5 oy','18000'); 
Query OK, 3 rows affected (0.06 sec) 
Records: 3 Duplicates: 0 Warnings: 0 
mysql> insert into Homashyo 
-> values(1,'yogli sut',1,'2022-10-25','Uchtepa tumani'), 


-> (2,'yogli sut',2,'2022-10-28','Toshloq tumani'), 
-> (3,'shakar',3,'2022-10-10','Angren shahar'), 
-> (4,'qand upasi',4,'2022-10-15','Angren shahar'), 
-> (5,'achitqi',5,'2022-09-25','Navoiy shahar'); 
Query OK, 5 rows affected (0.05 sec) 
Records: 5 Duplicates: 0 Warnings: 0 
mysql> insert into Yetkazuvchilar 
-> values(1,'Green Farm','Xayrulla Samadov','Uchtepa tumani','Akram Dolimov','200 
litr','2022-10-25','1'), 
(2,'Angren shakar','Asadulla Nematov','Angren Shahar','Izzatila Boburov','250 kg','2022-10-
10',3), 
-> (3,'Angren shakar','Bobur Xasanov','Angren shahar','Jasur Xasanov','210 kg','2022-10-
15',4), 
-> (4,'Navoiy sanoatzavodi MCHJ','Hoshim Islomov','Navoiy shahar','Farruh Odilov','120 
kg','2022-09-25',5); 
Query OK, 3 rows affected (0.02 sec) 
Records: 3 Duplicates: 0 Warnings: 0 
Select
mysql> select bolim_nomi,bolim_rahbari from bolimlar; 
mysql> select ismi,familiyasi,ish_bolimi,Lavozimi from hodimlar; 
mysql> select nomi,javobgar,ish_chiqarilgan,narxi from mahsulotlar
mysql> select nomi, yetkazuvchi_id, keldi from homashyo
mysql> select nomi,boshligi,manzili,xodim,hajmi,sanasi from yetkazuvchilar; 
mysql> select h_id,ismi,familiyasi,manzili,ish_bolimi,lavozimi,oyligi from hodimlar 
-> where ish_bolimi=1; 
mysql> select h_id,ismi,familiyasi,ish_bolimi,lavozimi,oyligi from hodimlar 
-> where oyligi<3600; 
mysql> select h_id,ismi,familiyasi,ish_bolimi,lavozimi,oyligi from hodimlar 
-> where oyligi>3500; 

Download 0.59 Mb.

Do'stlaringiz bilan baham:
1   2   3   4




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling