2-laboratoriya ishi fakultet: kif bajardi: Erkaboyeva Sanobar toshkent-2023

2. 
   - LABORATORIYA ISHI
   

1. 
   Kiritilgan ma’lumotlarni ko’rish
   
2. 
   select *
   from filiallar;
   

3. 
   Ishchilar jadvalimizdan created_date ni qabul_vaqtiga ga o’zgartiramiz
   

4. ALTER TABLE ishchilar

   
   RENAME COLUMN created_date TO qabul_vaqti;
   

5. 
   UPPER va ORDER BY funksiyasidan foydalanish
   

SELECT
UPPER(name)

6. 
   LENGTH va ORDER BY funksiyasidan foydalanish
   

7. 
   LOWER funksiyasidan foydalanish
   

8. 
   Jadvalga ustun qo’shish
   

9. 
   DROP buyrug’i orqali ustunni o’chirish
   
10. 
    alter table ishchilar drop column maosh
    

11. 
    UPDATE buyrug’idan foydalanish;
    
12. 
    UPDATE ishchilar
    SET name = 'Andrey'
    WHERE id = 1;