mahiyat aloqa diagrammasi

PDF 11 pages 1.2 MB Free download

Page preview (5 pages)

Scroll down 👇
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
mahiyat aloqa diagrammasi - Page 4
5 / 11
mahiyat aloqa diagrammasi - Page 5

Want to read more?

Download all 11 pages for free via Telegram.

Download full file

About "mahiyat aloqa diagrammasi"

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)...

This file contains 11 pages in PDF format (1.2 MB). To download "mahiyat aloqa diagrammasi", click the Telegram button on the left.

Tags: mahiyat aloqa diagrammasi PDF 11 pages Free download Telegram