Sql tilida index yaratish. Tasavvur, view yaratish va undan foydalanish


Men o’zimga berilgan predmet soha bo’yicha yaratgan MB ni


Download 350.2 Kb.
Pdf ko'rish
bet3/3
Sana17.06.2023
Hajmi350.2 Kb.
#1530881
1   2   3
Bog'liq
oybek MB

Men o’zimga berilgan predmet soha bo’yicha yaratgan MB ni 
Builder dasturiga bog’ladim va Ma’lumotlar bazasi yordamida 
oddiy interfeys yaratdim. 
mysql> insert into ishchilar 
-> values(1,'Nuriddin','Ergashev','3 yil','3 $','Namangan sh'); 
Query OK, 1 row affected (0.00 sec) 
mysql> insert into ishchilar 
-> values(2,'Mirzaakram','Meliboyev','5 yil','3 $','Namangan sh'); 
Query OK, 1 row affected (0.01 sec) 
mysql> select * from ishchilar; 
+----+------------+------------+-----------+--------+-------------+ 
| id | ismi | familiyasi | ish_staji | maoshi | manzili | 
+----+------------+------------+-----------+--------+-------------+ 
| 1 | Nuriddin | Ergashev | 3 yil | 3 $ | Namangan sh | 
| 2 | Mirzaakram | Meliboyev | 5 yil | 3 $ | Namangan sh | 
+----+------------+------------+-----------+--------+-------------+ 
2 rows in set (0.00 sec) 
 


mysql> select * from ishchilar; 
+----+------------+------------+-----------+--------+--------------+ 
| id | ismi | familiyasi | ish_staji | maoshi | manzili | 
+----+------------+------------+-----------+--------+--------------+ 
| 1 | Nuriddin | Ergashev | 3 yil | 3 $ | Namangan sh | 
| 2 | Mirzaakram | Meliboyev | 5 yil | 3 $ | Namangan sh | 
| 3 |OYBEK | YO’LDASHALIYEV | 20 yi | 7 $ | Namangan sh' | 
+----+------------+------------+-----------+--------+--------------+ 
3 rows in set (0.00 sec) 


Xulosa 
Men bu SQL tili orqali savdo tashkiloti haqida dastur tuzdim kelajakda buni 
takomillashtirilsa non markazidagilar uchun qulaylik vaqtni tejash uchun 
judayam foydali bo’ladi degan umiddama
 
 
 

Download 350.2 Kb.

Do'stlaringiz bilan baham:
1   2   3




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