mahiyat aloqa diagrammasi

PDF 11 sahifa 1,2 MB Bepul yuklash

11 sahifa

FaylHub.uz

Telegram orqali yuklab olish

Hajm 1,2 MB

Fayl turi PDF

Sahifalar 11

Yangilangan Dek 2025

Sahifa ko'rinishi (5 sahifa)

Pastga aylantiring 👇

1 / 11

1-topshiriq mohiyat aloqa diagrammasi mavzu : savdo tashkiloti 1.savdo tashkiloti bazani yaratib olamiz so’rov mysql> create database savto_tashkiloti; query ok, 1 row affected (0.00 sec) natijasi: 2.yaratgan bazani ko’rib va uni tanlab olamiz so’rov: show databases; so’rov: mysql> use savto_tashkiloti; database changed natijasi: 3.create table table name buyrugi ostida jadvallarimizni yaratib olamiz: so’rov: mysql> create table savdo_tashkiloti( -> id int auto_increment primary key, -> nomi varchar(50), -> manzili varchar(50), -> direktor_nomi varchar(50), -> soliq_raqami int); query ok, 0 rows affected (0.03 sec) mysql> create table yetkazib_beruvchilar( -> id int auto_increment primary key, -> nomi varchar(50), -> faoliyat_turi varchar(50), -> mamlakat varchar(50), -> shahar varchar(50), -> manzil varchar(50)); query ok, 0 rows affected (0.01 sec) mysql> create table savdo_nuqtasi( -> id int auto_increment primary key, -> nomi varchar(50), -> turi varchar(50), -> manzili varchar(50), -> bosh_nomi varchar(50)); query ok, 0 rows affected (0.02 sec) mysql> alter table savdo_nuqtasi -> add column …

2 / 11

olumn savdo_nuqtasi_id int, -> add foreign key (savdo_nuqtasi_id) references savdo_nuqtasi(id); query ok, 0 rows affected (0.02 sec) records: 0 duplicates: 0 warnings: 0 natijasi: 4.insert into buyrug’i asosida malumotlar qushamiz so’rov mysql> insert into yetkazib_beruvchilar (nomi, faoliyat_turi, mamlakat, shahar, manzil) -> values ('supplier1', 'faoliyat1', 'mamlakat1', 'shahar1', 'manzil1'), -> ('supplier2', 'faoliyat2', 'mamlakat2', 'shahar2', 'manzil2'); query ok, 2 rows affected (0.00 sec) records: 2 duplicates: 0 warnings: 0 mysql> insert into savdo_tashkiloti (nomi, manzili, direktor_nomi, soliq_raqami) -> values ('tashkilot1', 'manzil1', 'direktor1', 12345), -> ('tashkilot2', 'manzil2', 'direktor2', 67890); query ok, 2 rows affected (0.00 sec) records: 2 duplicates: 0 warnings: 0 mysql> insert into savdo_nuqtasi (nomi, turi, manzili, bosh_nomi, savdo_tashkiloti_id) -> values ('nuqta1', 'turi1', 'manzil1', 'boshnomi1', 1), -> ('nuqta2', 'turi2', 'manzil2', 'boshnomi2', 2); query ok, 2 rows affected (0.00 sec) records: 2 duplicates: 0 warnings: 0 mysql> insert into buyurtma (sanasi, mahsulot_nomi, miqdor, narx, savdo_nuqtasi_id) -> values ('2023-11-29', 'mahsulot1', '10', '100', 1), -> …

3 / 11

4; natijasi: 6.malumotlarni saralash so’rov mysql> select*from sotuvchi order by tugilgan_yili; natijasi: 7.malumotlarni o’chirish so’rov mysql> delete from sotuvchi where id=4; query ok, 1 row affected (0.01 sec) natijasi: 8.malumotlarni o’zgartirish so’rov mysql> update sotuvchi set ota_ism= -> "azizbek" where id=3; query ok, 1 row affected (0.00 sec) rows matched: 1 changed: 1 warnings: 0 natijasi: 9.jadvallarni o’chirish so’rov mysql> drop table sotuvchi; query ok, 0 rows affected (0.00 sec) natijasi: 10.jadval ustunlarini o’zgartirish so’rov mysql> -- drop the existing column mysql> alter table sotuvchi -> drop column yashash_manzili; query ok, 1 row affected (0.01 sec) records: 1 duplicates: 0 warnings: 0 mysql> mysql> -- add the new column mysql> alter table sotuvchi -> add column telefon_raqami varchar(20) after jinsi; query ok, 1 row affected (0.00 sec) natijasi:

4 / 11

5 / 11

Ko'proq o'qimoqchimisiz?

Barcha 11 sahifani Telegram orqali bepul yuklab oling.

To'liq faylni yuklab olish

"mahiyat aloqa diagrammasi" haqida

1-topshiriq mohiyat aloqa diagrammasi mavzu : savdo tashkiloti 1.savdo tashkiloti bazani yaratib olamiz so’rov mysql> create database savto_tashkiloti; query ok, 1 row affected (0.00 sec) natijasi: 2.yaratgan bazani ko’rib va uni tanlab olamiz so’rov: show databases; so’rov: mysql> use savto_tashkiloti; database changed natijasi: 3.create table table name buyrugi ostida jadvallarimizni yaratib olamiz: so’rov: mysql> create table savdo_tashkiloti( -> id int auto_increment primary key, -> nomi varchar(50), -> manzili varchar(50), -> direktor_nomi varchar(50), -> soliq_raqami int); query ok, 0 rows affected (0.03 sec) mysql> create table yetkazib_beruvchilar( -> id int auto_increment primary key, -> nomi varchar(50), -> faoliyat_turi varchar(50), -> mamlakat varchar(50), -> shahar varchar(50)...

Bu fayl PDF formatida 11 sahifadan iborat (1,2 MB). "mahiyat aloqa diagrammasi"ni yuklab olish uchun chap tomondagi Telegram tugmasini bosing.

Teglar: mahiyat aloqa diagrammasi PDF 11 sahifa Bepul yuklash Telegram