Mavzu: Murakkab so‘rovlar yaratish. Sql tilida index yaratish. Tasavvur, view yaratish va undan foydalanish. Sql da funksiyalar yaratish. Sql da triggerlar 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.
http://fayllar.org