Id int not null primary key, raqobatchilar varchar(30)

2 topshiriq

CREATE TABLE hamkorlik

(
id INT NOT NULL PRIMARY KEY,
raqobatchilar VARCHAR(30),
televideniya VARCHAR(40),
xususiy_firma VARCHAR(35),
zavod VARCHAR(25)
);
CREATE TABLE supermarkethaqida
(
id INT NOT NULL PRIMARY KEY,
rahbar VARCHAR(30),
manzil VARCHAR(25),
xudud VARCHAR(20),
email VARCHAR(40)
);
CREATE TABLE homiylar
(
id INT NOT NULL PRIMARY KEY,
shaxsturi VARCHAR(30),
otkazilganmablag float
);
CREATE TABLE kirimchiqim
(
id INT NOT NULL PRIMARY KEY,
sarflangan INT,
foyda INT
umumiysumma INT,
);
CREATE TABLE mahsulotlar
(
id INT NOT NULL PRIMARY KEY,
mahsulotnomi VARCHAR(10),
mahsulotturi VARCHAR(20),
narx INT
);
CREATE TABLE soliqlar
(
id INT NOT NULL PRIMARY KEY,
suv INT,
elektr INT,
chiqindi INT
);
CREATE TABLE mijozlar
(
id INT NOT NULL PRIMARY KEY,
manzili VARCHAR(30),
xizmztkodi VARCHAR(25),
narxi INT(20)
);
CREATE TABLE zaxira
(
id INT NOT NULL PRIMARY KEY,
oziqovqat VARCHAR(50),
xamoshiyo VARCHAR(45),
mablag INT(40),
inustirimintlar VARCHAR(35)
);
CREATE TABLE xizmatkursatish
(
id INT NOT NULL PRIMARY KEY,
xizmatnomi VARCHAR(40)
);
CREATE TABLE bolimlar
(
id INT NOT NULL PRIMARY KEY,
sinvol VARCHAR(10),
qavati INT(10),
masulishchi VARCHAR(40),
turi VARCHAR(40)
);
2 – Topshiriq
Jadvalga yangi malumot qushish
Hamkorlik jadvaliga malumot qushish
INSERT INTO hamkorlik(id, raqobatchilar, televideniya, xususiy_firma, zavod) VALUES (1, "qwert", "zo’r tv","Davron","aftamabi")
INSERT INTO hamkorlik(id, raqobatchilar, televideniya, xususiy_firma, zavod) VALUES (2, "vyub", "uz tv","ctyv","xrcty")
INSERT INTO hamkorlik(id, raqobatchilar, televideniya, xususiy_firma, zavod) VALUES (3, "xvchj", “fudbol tv","navroz","kampyuter")
INSERT INTO hamkorlik(id, raqobatchilar, televideniya, xususiy_firma, zavod) VALUES (4, "gjhu", "milliy tv","iskandar","kampyuter")
INSERT INTO hamkorlik(id, raqobatchilar, televideniya, xususiy_firma, zavod) VALUES (5, "raqabat", "uz tv","dilshod","kampyuter")
INSERT INTO hamkorlik(id, raqobatchilar, televideniya, xususiy_firma, zavod) VALUES (6, "raqabat", "uz tv","aziz","kampyuter")
INSERT INTO hamkorlik(id, raqobatchilar, televideniya, xususiy_firma, zavod) VALUES (7, "raqabat", "uz tv","davron","kampyuter")
INSERT INTO hamkorlik(id, raqobatchilar, televideniya, xususiy_firma, zavod) VALUES (8, "raqabat", "uz tv","berdiyor","kampyuter")