Create table maktab (id integer, Familyasi char (25), Ismi char (20), Sharfi char


Download 22.5 Kb.
Sana20.01.2023
Hajmi22.5 Kb.
#1103463
Bog'liq
mustaqil ish 111


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);
Download 22.5 Kb.

Do'stlaringiz bilan baham:




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling