supermarketning mohiyat-aloqa diagrammasi

PPTX 24 стр. 3,1 МБ Бесплатная загрузка

24 стр.

FaylHub.uz

Скачать через Telegram

Размер 3,1 МБ

Тип файла PPTX

Страницы 24

Обновлено Дек 2025

Предварительный просмотр (5 стр.)

Прокрутите вниз 👇

1 / 24

prezentatsiya powerpoint “supermarket” ning mohiyat-aloqa diagrammasi 2-labaratoriya ishi “supermarket”ning relyatsion modeli 3-laboratoriya ishi sql tilida jadvallar yaratish, o‘zgartirish va o‘chirish. labaratoriya ishi-4 ma’lumotlarni tanlash va ular ustida amallar 5- laboratoriya ishi and, or, not mantiqiy standart so‘zlardan foydalanish. 6-laboratoriya ishi ma’lumotlarni saralash. where standart so‘zidan foydalanish 7- laboratoriya ishi group by va order by standart so‘zlaridan foydalanib so‘rov yaratish. 8-labarotoriya having standart so‘zi orqali so‘rovlar yaratish. 1. 2. 9-laboratoriya ishi union, intersect va minus standartso‘zlaridan foydalanish. 2. 3. 10-labaratoriya ishi 11-labaratoriya ishi 12-labaratoriya ishi 12-labaratoriya ishi 13-labaratoriya murakkab so‘rovlar yaratish. top, limit yoki rownum limit bilan ishlash image6.png image7.png image8.png image9.png image10.png image11.png image12.png image13.png image14.png image15.png image16.png image17.png image18.png image19.png image20.png image21.png image22.png image23.png image24.png image25.png image26.png image27.png image28.png image29.png image30.png image31.png image32.png image33.png image34.png image35.png image36.png image37.png image38.png image39.png image40.png image41.png image42.png image43.png image44.png image45.png image2.png image3.png image4.png image5.png 1 a y 1 osmania balin, bolimlar sia coat, …

2 / 24

",19); mysql> select*from foydalanuvchi; | f_id | # familiyasi | f_sohasi | yoshi i | 1 | yusupova | talaba | 19 | eocsese== 1 row in set (0.00 sec) ery ok, @ rows affected (0.80 sec) ‘sqi> alter table toydalanuvchi add manzili varchar(30); ju me @ duplicates: @ warnings: @ leal opihie goblet cat coat? where ¢ facies query ok, 1 row affected (0.23 sec) rows matched: 1 changed: 1 warnings: @ ‘usupova"; mysql> select*from foydalanuvchi; + a a = | fad | #_familiyasi | f_sohasi | yoshi | manzili | = = + | 1 | yusupova | talaba | 19 | navoiy | + oe — + 1 row in set (0.00 sec) ‘sql> drop table 9_oct; uery ok, @ rows affected (0.40 sec) sql> show tables; empty set (0.00 sec) mysql> insert into badiiy kitoblar(b_id,b_nomi,b muallifi,b yili) values(2,"otamdan qolgan dalalar™,"t.murod™ , 1987) ; query ok, 1 …

3 / 24

) | + = = | 2 | halimov | professor | | 3 | axmadjonov | o*qituvcht | | 4 | nasiraliyev | 3d grapher | + oe 3 mysql> select f_id, substr(f_familiyasi,1,1)||‘.'||*_sohasi, f_familiyasi,manzili, length(f_sohasi),f_sohasi from foydalanu} vchi where f_id in(1,2,3) and yoshi>20; fea = [| €2d |) ata acalyast.a.a)|°.9[|sotced || cecile || cma || legacies) |) cece | = — + | 2 | ® | halimov | navoiy | 9 | professor | | 3] ® | axmadjonov | namangan | 10 | o “artes | + or 2 rows in set, 4 warnings (0.15 sec) mysql> desc badiiy_kitoblar; ‘| field | type | bid | int(11) | no | b_nomi- | varchar(255) | yes | b_muallifi | varchar(255) | yes i | | yes 4 rows in set (0.39 sec) mysql> desc foydalanuvchi; | f_id | int(11) | no | f_familiyasi | varchar(255) | yes '| …

4 / 24

key(id) => 3 uery ok, @ rows affected (1.49 sec) mysql> desc gazeta; | int(11) | no | pri | null | | g_nomi | varchar(25) | yes | | null | | | g_nashriyoti | varchar(25) | yes | | wut | | — oe + 3 rows in set (0.01 sec) mysql> select max(f_id) as ‘eng oxirgi foydalanuvchi’ from foydalanuvchi; | eng oxirgi foydalanuvchi | 1 row in set (@.00 sec) mysql> update gazeta set g_nomi=null where g_id: query ok, 1 row affected (0.47 sec) rows matched: 1 changed: 1 warnings: 0 mysql> select*from gazeta => § aecs= | gid | g nomi sense | 1 | xalq so'zi | 2005 | | 2 | vatanparvar | 2002 | | 3 | null | 2003 | + oe 3 rows in set (0.00 sec) | mysql> delete from gazeta where g_nomi is null; query ok, 1 row affected …

5 / 24

t=from foydalanuvchi order by f_familiyasi fotocas * * : + peesc; fad | £familiyasi | fsohasi | yoshi | manzili + (se i cee us ssl vdot eas te romitiyesi | fsohesi | yoshi | wanzili | | 3. | axmadjonov | o'gituvchi | 27 | nomangon | hm" vucupova’ | talaba yaa | navoly | | 2 | helimov | professor | 56 | navoiy | mil 4 | nasiraliyev | 3d grapher | 29 | namangan | | 4 | nasiraliyev | 3d grapher | 29 | namangan | mj > | halimov | professor | 56 | navoiy | | 1 | yusupova | talaba =| 19 | navoiy | hm] 3 | axmadjonov | o'qituvchi | 27 | namangan | omy sects (peep oe) ares fig oo ee) sql> select*from foydalanuvchi having yoshi select yoshi as ‘foydalanuvchilarni yoshi boyicha guruhlash’,count(f_familiyasi) as ‘foydalanuvchilar soni‘ rom foydalanuvchi group …

Хотите читать дальше?

Скачайте все 24 страниц бесплатно через Telegram.

Скачать полный файл

О "supermarketning mohiyat-aloqa diagrammasi"

prezentatsiya powerpoint “supermarket” ning mohiyat-aloqa diagrammasi 2-labaratoriya ishi “supermarket”ning relyatsion modeli 3-laboratoriya ishi sql tilida jadvallar yaratish, o‘zgartirish va o‘chirish. labaratoriya ishi-4 ma’lumotlarni tanlash va ular ustida amallar 5- laboratoriya ishi and, or, not mantiqiy standart so‘zlardan foydalanish. 6-laboratoriya ishi ma’lumotlarni saralash. where standart so‘zidan foydalanish 7- laboratoriya ishi group by va order by standart so‘zlaridan foydalanib so‘rov yaratish. 8-labarotoriya having standart so‘zi orqali so‘rovlar yaratish. 1. 2. 9-laboratoriya ishi union, intersect va minus standartso‘zlaridan foydalanish. 2. 3. 10-labaratoriya ishi 11-labaratoriya ishi 12-labaratoriya ishi 12-labaratoriya ishi 13-labaratoriya murakkab so‘rovlar yaratish. ...

Этот файл содержит 24 стр. в формате PPTX (3,1 МБ). Чтобы скачать "supermarketning mohiyat-aloqa diagrammasi", нажмите кнопку Telegram слева.

Теги: supermarketning mohiyat-aloqa d… PPTX 24 стр. Бесплатная загрузка Telegram