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.
Do'stlaringiz bilan baham: |