shahar ma’lumotlar bazasi

PPTX 17 стр. 675,7 КБ Бесплатная загрузка

17 стр.

FaylHub.uz

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

Размер 675,7 КБ

Тип файла PPTX

Страницы 17

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

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

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

1 / 17

prezentatsiya powerpoint toshkent axborot texnologiyalari universtetining komputer injiniringi fakulteti 210-20-guruh talabasi qarshiboyev sirojiddinning ma’lumotlar bazasi fanidan yozgan 2-mustaqil ishi bajardi:qarshiboyev sirojiddin tekshirdi:malikova nodira mavzu:”shahar” ma’lumotlar bazasi ma’lumotlar bazasini yaratish: 5-laboratoriya ishi. 6-laboratoriya ishi 7-laboratoriya ishi 8-laboratoriya ishi image1.png image2.png image3.png image4.png image5.png 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 mysql> select*from hokimyat; x - | 901230001 | 1 i | ® | 2 | saidbek | @ | 901234569 | 3 | sunnat | ®@ | 901569569 | 4 | sardor | @ | 902369569 | 5 | elbek | ®@ | 903659569 | 6 | bekzod | @ | 902367569 6 rows in set (0.00 sec) ae | tel_raqami | elektron_pochtasi | | @sirojiddin_001 | @saidbek_002 | @sunnat_@03 | @sardor_@04 | @elbek_005 | @bekzod_006 ny …

2 / 17

here id between 1 and 2; sos hhessssssesssssssesssssssess= es sh) | elektron_pochtasi | length(elektron_pochtasi) | oylik | = 1 | sirojiddin | @sirojiddin_ee1 | 15 | 70000 | 2 | saidbek | @saidbek_002 | 12 | 60000 | wane i 2 rows in set (0.00 sec) sql> use shahar; atabase changed sql> show tables; | aholi i | hokimyat i | mahalla i | tuman i} rows in set (0.00 sec) sql> desc aholi; nanan nena nn nt anne snes oan nae sa eeeeneg field | type | null | key | default | extra | ne et nee soe oan sanaa eneg | id | int(11) | yes | | null | | | fuqaroligi | varchar(1e) | yes | | null | | | yoshi | varchar(10) | yes | | null | | aan-t- + + rows in set (0.02 sec) sql> desc hokimyat; + + | …

3 / 17

| nomi | tashkil_qilingal —— = = n_yili | sigimi | 1983 | 10000 | 1970 | 20000 | 2000 | rows in set (0.00 sec) sql> insert into aholi values(1, ‘ozbekiston_respublikasi’, 20); ery ok, 1 row affected, 1 warning (@.@2 sec) sql> insert into aholi values(2, ‘ozbekiston_respublikasi', 22); ery ok, 1 row affected, 1 warning (0.00 sec) sql> insert into aholi values(3, ‘ozbekiston_respublikasi', 20); uery ok, 1 row affected, 1 warning (2.0 sec) sql> insert into aholi values(3, ‘rossiya_respublikasi', 21); ery ok, 1 row affected, 1 warning (9.01 sec) sql> select*from aholi; ao ne sarre | id | fuqaroligi | yoshi | aann-- ne errors 1 | ozbekiston | 20 | 2 | ozbekiston | 22 | 3 | ozbekiston | 20 | 3 | rossiya_re | 21 | aann-- ore sa ranrees rows in set (0.00 sec) mysql> insert into hokimyat query ok, 1 row affected, 1 mysql> …

4 / 17

aidbekoe2 yugori | 60ee0 | sardor | @ | 901232765 | @sardoree3 yugori | 50eee | elbek | @ | 901232767 | @elbekooa yugori | 40ee0 | bekzod | @ | 901232768 | @bekzodees yugori | 200e0 | honccccc anne nes see a oer nnes fonncn- + 11 rows in set (0.00 sec) sql> insert into mahalla values(1, ‘shahriston’, 2000, ‘yunusobod'); ery ok, 1 row affected (0.02 sec) sql> insert into mahalla values(2, ‘bodomzor’, 2500, ‘yunusobod'); ery ok, 1 row affected (@.01 sec) sql> insert into mahalla values(3, ‘taraqgiyot', 2800, ‘mirobod"); ery ok, 1 row affected (8.00 sec) sql> select*from mahalla; | id | nomi | aholi_soni | joylashuv | foncccn anne + | 1 | shahriston | 2000 | yunusobod | | 2 | bodomzor | 2500 | yunusobod | | 3 | taraqqiyot | 2800 | mirobod | aann-- ne soo ans oe aren neers 3 rows in …

5 / 17

alter table tuman add oliygoh_id int; query ok, @ rows affected (0.05 sec) records: @ duplicates: @ warnings: 0 mysql> alter table tuman add hokimyat_id int; query ok, @ rows affected (0.03 sec) records: @ duplicates: @ warnings: 0 mysql> alter table tuman add aholi_id int; query ok, @ rows affected (0.06 sec) records: @ duplicates: @ warnings: 0 sql> update oliygoh set aholi_id=1 where ery ok, 1 row affected (0.00 sec) rows matched: 1 changed: 1 warnings: @ sql> update oliygoh set aholi_id=1 where ery ok, 1 row affected (0.00 sec) rows matched: 1 changed: 1 warnings: @ sql> update oliygoh set aholi_id=1 where ery ok, 1 row affected (0.00 sec) rows matched: 1 changed: 1 warnings: @ sql> update oliygoh set aholi_id=1 where ery ok, @ rows affected (0.00 sec) rows matched: @ changed: @ warnings: @ sql> update oliygoh set aholi_id=1 where ery ok, @ rows affected …

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

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

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

О "shahar ma’lumotlar bazasi"

prezentatsiya powerpoint toshkent axborot texnologiyalari universtetining komputer injiniringi fakulteti 210-20-guruh talabasi qarshiboyev sirojiddinning ma’lumotlar bazasi fanidan yozgan 2-mustaqil ishi bajardi:qarshiboyev sirojiddin tekshirdi:malikova nodira mavzu:”shahar” ma’lumotlar bazasi ma’lumotlar bazasini yaratish: 5-laboratoriya ishi. 6-laboratoriya ishi 7-laboratoriya ishi 8-laboratoriya ishi image1.png image2.png image3.png image4.png image5.png 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 image3...

Этот файл содержит 17 стр. в формате PPTX (675,7 КБ). Чтобы скачать "shahar ma’lumotlar bazasi", нажмите кнопку Telegram слева.

Теги: shahar ma’lumotlar bazasi PPTX 17 стр. Бесплатная загрузка Telegram