"tuman" ma’lumotlar bazasi

PPTX 16 стр. 2,4 МБ Бесплатная загрузка

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

Прокрутите вниз 👇
1 / 16
prezentatsiya powerpoint toshkent axborot texnologiyalari universtetining komputer injiniringi fakulteti 210-20-guruh talabasi nomozov bekzodning ma’lumotlar bazasi fanidan yozgan 2-mustaqil ishi bajardi:nomozov bekzod tekshirdi:malikova nodira mavzu:”tuman” ma’lumotlar bazasi reja: 1. ma’lumotlar bazasini yaratish ma’lumotlar bazasini yaratish 5-laboratoriya ishi 6 - laboratoriya ishi 7 - laboratoriya ishi 8 - laboratoriya ishi 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 image2.png image3.png image4.png image5.png mysql> select*from | 1 | artel | | 2 | tikuv_sex | | 3 | neft-gaz | | 4 | asaka | | 5 | yuksalish | | 6 | qurulish | a korhona; joylashuv: sergili_xonobod_mahalla yunusobod_shaxriston_mahalla chirchig_oqgorgon_mahallasi asaka_tumani toshken shahri sergili tumani 6 rows in set (0.00 sec) ish_vaqti 3 7 8 in rssach sssee s33ss nv ipiple s88sss .textel.uz -neft_gaz.uz asaka.uz -yuksalish.uz -quruvchi.uz mysql> select id, nomi, upper(web_sayti) …
2 / 16
tikuv_sex | 11 | www.textel.uz | 120000 | | asaka | 11 | www.asaka.uz | 15000 | | yuksalish | 11 | www.yuksalish.uz | 50000 | | qurulish | 11 | www.quruvchi.uz | 90000 | — a — 5 rows in set (0.00 sec) mysql> select id, lower(nomi), joylashuvi,length(joyleshuvi), oyligi from korhona where id between 1 and 2; os == | id | lower(nomi) | joylashuvi a [| remsth exalts) | oyligi | | 1 | artel | sergili_xonobod_mahalla i | 2 | tikuv_sex | yunusobod_shaxriston_mahalla | 23 | 7ee00 | 28 | 120000 | eae hosoatk = 2 rows in set (0.00 sec) “+ mysql> show tables from tuman; | tables_in_tuman | — + | axoli | hokimyat | | korhona | | + mahalla talim_muassasasi ue 5 rows in set (0.00 sec) mysql> desc axoli; | field | type | null | key | id | int(41) | …
3 / 16
(30), -> talabalar_soni int —> )5 query ok, @ rows affected (0.13 sec) mysql> desc talim_muassasasi; | field | type | null | key | default | extra | = a id | int(41) | no | | null | | nomi | varchar(5@) | yes | | null. | | joylashuvi | varchar(3@) | yes | | null | | talabalar_soni | int(11) | yes | | null. | | = + 4 rows in set (0.01 sec) mysql> insert into hokimyat query ok, 1 row affected (@. mysql> insert into hokimyat query ok, 1 row affected (@. mysql> insert into hokimyat query ok, 1 row affected (@. mysql> insert into hokimyat query ok, 1 row affected (@. mysql> select*from hokimyat; a === = | id | fish i} = === = re = + | 1 | safarov saidbek | tuman hokimi- | 903455566 | hokim@e@gmail.com | | …
4 / 16
7ee0ee | | 2 | tikuv_sex | yunusobod_shaxriston_mahalla :00 | www.textel.uz | 120000 | | 3 | neft-gaz | chirchiq_oqgorgon_mahallasi 00 | www.neft_gaz.uz | 100000 | | 4 | asaka | asaka_tumani 00 | www.asaka.uz | 15000 | | 5 | yuksalish | toshken shahri 00 | www.yuksalish.uz | 50000 | | 6 | qurulish | sergili tumani 00 | www.quruvchi.uz | 90000 | | 7 | tilla kon | jizzax moynog :00 | www.tillakon.uz | 75000 | | 8 | bunyodkor | toshkent chilonzor 00 | www.bunyodkor.uz | 95000 | a = + 8 rows in set (0.00 sec) mysql> insert into mahalla values('5', ‘sharof rashidov', '13-ming', '32-km*2"); query ok, 1 row affected (0.00 sec) mysql> insert into mahalla values('6', ‘baxmal', '19-ming', '23-km*2'); query ok, 1 row affected (0.09 sec) mysql> insert into mahalla values('7', ‘zomin', '29-ming', '29-km*2'); query ok, 1 row affected (0.00 sec) mysql> insert into mahalla …
5 / 16
bek ss a 4 rows in set (0.00 sec) mysql> alter table talim_muassasasi add korhona_id int; query ok, @ rows affected (0.06 sec) records: @ duplicates: @ warnings: @ mysql> alter table talim_muassasasi add mahalla_id int; query ok, @ rows affected (0.05 sec) records: @ duplicates: @ warnings: @ mysql> alter table axoli add mahalla_id int; query ok, @ rows affected (0.05 sec) records: @ duplicates: @ warnings: @ mysql> alter table axoli add hokimyat_id int; query ok, @ rows affected (0.06 sec) records: @ duplicates: @ warnings: @ mysql> alter table axoli add talim_id int; query ok, @ rows affected (0.05 sec) records: @ duplicates: @ warnings: @ mysql> alter table mahalla add hokimyat_id int; query ok, @ rows affected (0.05 sec) records: @ duplicates: @ warnings: @ mysql> alter table mahalla add korhona_id int; query ok, @ rows affected (0.13 sec) records: @ duplicates: @ warnings: @ mysql> …

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

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

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

О ""tuman" ma’lumotlar bazasi"

prezentatsiya powerpoint toshkent axborot texnologiyalari universtetining komputer injiniringi fakulteti 210-20-guruh talabasi nomozov bekzodning ma’lumotlar bazasi fanidan yozgan 2-mustaqil ishi bajardi:nomozov bekzod tekshirdi:malikova nodira mavzu:”tuman” ma’lumotlar bazasi reja: 1. ma’lumotlar bazasini yaratish ma’lumotlar bazasini yaratish 5-laboratoriya ishi 6 - laboratoriya ishi 7 - laboratoriya ishi 8 - laboratoriya ishi 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 image2.png image3.png image4.png im...

Этот файл содержит 16 стр. в формате PPTX (2,4 МБ). Чтобы скачать ""tuman" ma’lumotlar bazasi", нажмите кнопку Telegram слева.

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