Amaliy matematika informatika yo’nalishi

 
SQLda INSERT operatorlari yordamida jadvallarga yozuvlar qo’shish 
“Supermarket” jadvaliga INSERT operatori yordamida yozuv qo’shish 
Supermarket jadvalini INSERT operatori yordamida hosil qilish. 
1.INSERT INTO supermarket VALUES (1, 'idsupermarket' ,'Supermarketname', 
'supermarketsite','supermarketnumber','supermaketmanager'); 
2.INSERT 
INTO 
supermarket 
VALUES 
(2, 
'idsupermarket1' 
,'Supermarketname', 'supermarketsite','supermarketnumber','supermaketmanager'); 
3.INSERT 
INTO 
supermarket 
VALUES 
(3, 
'idsupermarket2' 
,'Supermarketname', 'supermarketsite','supermarketnumber','supermaketmanager'); 
Employee jadvalini INSERT operatori yordamida hosil qilish. 
1.INSERT INTO employee VALUES (1, 'idemployee1', 'employeename', 
'employeesalary','employeetelephone','employeeadress'); 
2.INSERT INTO employee VALUES (2, 'idemployee2', 'employeename', 
'employeesalary','employeetelephone','employeeadress'); 
3.INSERT INTO employee VALUES (3, 'idemployee3', 'employeename', 
'employeesalary','employeetelephone','employeeadress'); 
4.INSERT INTO employee VALUES (4, 'idemployee4', 'employeename', 
'employeesalary','employeetelephone','employeeadress'); 
5.INSERT INTO employee VALUES (5, 'idemployee5', 'employeename', 
'employeesalary','employeetelephone','employeeadress'); 
 

---

24 
24 
Department jadvalini department operatori yordamida hosil qilish 
1.INSERT INTO departmentVALUES (1, 'iddepartment','departmentname', 
'departmentleader','departmentnumber','departmentemployee'); 
2.INSERT INTO departmentVALUES (2, 'iddepartment','departmentname', 
'departmentleader','departmentnumber','departmentemployee'); 
3.INSERT INTO departmentVALUES (3, 'iddepartment','departmentname', 
'departmentleader','departmentnumber','departmentemployee'); 
4.INSERT INTO departmentVALUES (4, 'iddepartment','departmentname', 
'departmentleader','departmentnumber','departmentemployee'); 
5.INSERT INTO departmentVALUES (5, 'iddepartment','departmentname', 
'departmentleader','departmentnumber','departmentemployee');