Maktab jadvalini yarаtish
CREATE TABLE Maktab
(ID integer,
Familyasi char (25),
Ismi char (20),
Sharfi char (15),
Maktabning joylashuvi integer);
Maktab jadvalini ma’lumotlar bilan to’ldirish quydagicha bajariladi.
INSERT INTO Salespeople VALUES (1001, ‘Sobirov’,‘Raxim’,’Navoiy’,12);
INSERT INTO Salespeople VALUES (1002, ‘Qosimov’,‘Sodiq’,’Samarqand’,11);
INSERT INTO Salespeople VALUES (1004, ‘Muhammadiev’,‘Lapas’,’Farg’ona’,11);
INSERT INTO Salespeople VALUES (1007, ‘Razzoqov’,‘Asam’, ’Samarqand’,15);
INSERT INTO Salespeople VALUES (1003, ‘Asqarov’,‘Nodir’,’Namangan’,10);
Do'stlaringiz bilan baham: |