Yangi axborot texnologiyalarining yaratilishi va ularning jamiyat turli

10-jadval. “Order” jadvalini CREATE operatori yordamida hosil qilish 
CREATE TABLE product_has_Order ( 
idOrderINT(3) NOT NULL PRIMARY KEY, 
Orderamount VARCHAR(55) NOT NULL); 

---

11-jadval. “Productbesoldnumber” jadvalini CREATE operatori yordamida 
hosil qilish 
CREATE TABLE Productbesoldnumber ( 
id Productbesoldnumber INT(3) NOT NULL PRIMARY KEY, 
Productbesoldnumbername VARCHAR(55) NOT NULL, 
product_idproduct INT(3) NOT NULL, 
product_producttype_idproducttype INT(3) NOT NULL 
); 
12-jadval. “Productresidues” jadvalini CREATE operatori yordamida hosil 
qilish 
CREATE TABLE Productbesoldnumber ( 
idProductresidues INT(3) NOT NULL PRIMARY KEY, 
Productresiduesname VARCHAR(55) NOT NULL, 
product_idproductINT(3) NOT NULL, 
product_producttype_idproducttype INT(3) NOT NULL 
); 
5. SQL operatorlari yordamida jadvallarga yozuvlar qshish 
1-jadval. “Onlineshop” jadvaliga INSERT operatori yordamida yozuv qshish 
INSERT INTO Onlineshop VALUES (1, 'Gulasal, 'Samarqand shahar Bobur kcha 
24-uy, '238-43-23', ‘@dsfs456’); 
INSERT INTO Onlineshop VALUES (2, 'Sevara’, 'Navoiy shahar Oqtosh kuchasi 
34-uy’ , '983-23-43', ‘@hsg67ss’); 
INSERT INTO Onlineshop VALUES (3, 'Marvarid, 'Samarqand shahar Mirzo 
mahalla’ 8-uy', '998-23-53’,; @gxgsf656’); 
INSERT INTO Onlineshop VALUES (4, `Wonderfull’, 'Toshkent shahar bekbaraka 
18-uy', '523-43-08, @hjwg6777dhe’); 

---

2-jadval. “Depertment” jadvaliga INSERT operatori yordamida yozuv qshish 
INSERT INTO DepertmentVALUES (1, ‘hisob bulimi’); 
INSERT INTO Depertment VALUES (2, 'xodimlar bulimi'); 
INSERT INTO Depertment VALUES(3, 'mahsulotlar junatish bulimi');