Mavzu: Murakkab so’rovlar yaratish


Download 405.5 Kb.
bet3/3
Sana24.12.2022
Hajmi405.5 Kb.
#1056757
1   2   3
Bog'liq
Lab 6

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 405.5 Kb.

Do'stlaringiz bilan baham:
1   2   3




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