Mavzu: Murakkab so‘rovlar yaratish. Sql tilida index yaratish. Tasavvur, view yaratish va undan foydalanish


Download 406.54 Kb.
bet3/3
Sana17.01.2023
Hajmi406.54 Kb.
#1097891
1   2   3
Bog'liq
Mavzu Murakkab so’rovlar yaratish

Drop views

mysql> drop view murakkab;


Query OK, 0 rows affected (0.00 sec)

mysql> drop view info_samalyot;


Query OK, 0 rows affected (0.00 sec)

mysql> show full tables;


+----------------------------+------------+
| Tables_in_aeroport | Table_type |
+----------------------------+------------+
| aeroport_hodimlari | BASE TABLE |
| chipta_savdosi_bayonnomasi | BASE TABLE |
| parvozlar | BASE TABLE |
| samalyot_ekipajlari | BASE TABLE |
| samalyotlar | BASE TABLE |
+----------------------------+------------+
5 rows in set (0.00 sec)

mysql>




Xulosa:
Men ushbu laboratoriya ishida murakkab so’rovlar yaratish bo`yicha ko`nikmaga ega bo`ldim, berilgan predmet soha ma`lumotlar bazasidagi barcha ob`yektlarni ustida INDEXlar va VIEWlar yaratish asosida amallarini bajarishni o`rgandim.
Download 406.54 Kb.

Do'stlaringiz bilan baham:
1   2   3




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