Labarotoriya ishi

O’zbekiston Respublikasi Axborot Texnologiyalari va

Kommunikatsiyalarini Rivojlantirish Vazirligi
Muhammad Al-Xorazmiy nomidagi
Toshkent Axborot Texnologiyalari Universiteti.

LABAROTORIYA ISHI

Xudoyberdiyev Mahmud


Toshkent 2022
Laboratoriya ishi

MAVZU: SQL tilida INDEX yaratish. Tasavvur (VIEW) yaratish va undan foydalanish. SQLda protseduralar yaratish.

ISHDAN MAQSAD: SQL da murakkab so’rovlardan foydalanib ba’zi amallarni bajarish.

REJA:
1.Jadvallarning kerakli qismida INDEx yaratish
2.VIEW larni yaratish va ulardan foydalanish.
3.MySQL da maxsus TRIGGER (INSERT,UPDATE,DELETE) yaratish.


1.Jadvallarning kerakli qismida INDEx yaratish
Create index email1 on mijoz(email)

INDEXni o’chirish.
DROP INDEX email1 on mijoz;

2.VIEW larni yaratish va ulardan foydalanish.
Create VIEW mijoz1 AS Select ID, FISH, email from mijoz;






3.MySQL da maxsus TRIGGER (INSERT,UPDATE,DELETE) yaratish.