6-topshiriq. Sqlda ma’lumotlarni manipulyatsiya qilish topshiriq mazmuni. Quyidagi topshiriqlar bajarilsin

6.3. SQL tili orqali jadvallardagi ma’lumotni tahrirlash. Relatsion model(3-topshiriq)da hosil qilingan jadvallardagi bittadan ma’lumotni UPDATE operatori orqali tahrirlang.

1. 
   UPDATE About_TTJ SET `Name`="Uchinchi sonli",`Address`="samarqand shahar",`Komendat`="Hilola",`Phone`="[phone]" WHERE idAbout=2
   
2. 
   UPDATE Book_keeping SET `Salary`="200$",`Outlay`="20$" WHERE idBook_keeping=2
   
3. 
   UPDATE Control1 SET `Date`="02.02.2022",`Name`="Guli" WHERE idControl=2
   
4. 
   UPDATE DUTY1 SET `Floor_number`="7-qavat",`Sections`="10",`ROOM`="10",`Date`="07.07.2022" WHERE idDuty=2
   
5. 
   UPDATE Furniture1 SET `sport_furniture`="7",`kitchen_furniture`="7",`bedroom_furniture`="07.07.2022" WHERE idfurniture=2
   
6. 
   UPDATE Officers1 SET `furniture`="7",`officio`="komendat",`phone`="[phone]",`work_experience`="7",`salary`="1000$" WHERE idOfficers=2
   
7. 
   UPDATE Rooms1 SET `Name`="sportzali",`The_number_of`="2" WHERE idRooms=2
   
8. 
   UPDATE Sections1 SET `Name`="Buxgalteriya",`Adjutancy`="hisobchi",`Number_of_employees`="7" WHERE idSections=5
   
9. 
   UPDATE Students1 SET `Full_name`="Nurmatov Shahzod",`The_number_of`="700",`Address`="Jizzax viloyati Baxmal tumani",`Faculty`="Raqamli texnologiyalar",`Phone_number`="7" WHERE idStudents=1
   

6.4. SQL tili orqali jadvallardagi ma’lumotni o’chirish. Relatsion model(3-topshiriq)da hosil qilingan jadvallardagi bittadan ma’lumotni DELETE operatori orqali o’chirish.
1. DELETE FROM About_TTJ WHERE `Name`<7
2. DELETE FROM Book_keeping WHERE `Outlay`<7
3. DELETE FROM Control1 WHERE `idControl`>4 AND `idControl`<=7
4. DELETE FROM DUTY1 WHERE NOT`room`="room"
5. DELETE FROM Furniture1 WHERE `sport_furniture`<3
6. DELETE FROM `Officers1` WHERE 'idofficers1'>2 and ' officers1'<5
7. DELETE FROM `Rooms1` WHERE 'Name'="yotoqxona"
8. DELETE FROM Sections1 WHERE `Name`="oshxona" AND `Adjutancy`="oshpaz"
9. DELETE FROM `Students1` WHERE 'FULL_Name'="Umirov Faxriddin"