Samarqand davlat universiteti raqamli texnologiyalar fakulteti amaliy matematika informatika yo

7-jadval. “Ma’nviyat bo’limi” jadvaliga INSERT operatori yordamida yozuv qo’shish
INSERT INTO manaviyat_bolimi VALUES (1, 'Muzqaymoq_party’, ‘Samarqand shahriga sayohat', 'Yosh kitobxon tanlovi’);

INSERT INTO manaviyat_bolimi VALUES (2, 'Super kuyov’, ‘Samarqand shahri Registonga sayohat', 'Amaliy ish’);

INSERT INTO manaviyat_bolimi VALUES (3, 'konsert’, ‘qadimiy qadamjolar', 'Kitob mutolaa’);

INSERT INTO manaviyat_bolimi VALUES (4, 'Real xit’, ‘Muzeyga sayohat', 'bilimlar bellashuvi’);

8-jadval. “Oziq-ovqat” jadvaliga INSERT operatori yordamida yozuv qo’shish
INSERT INTO oziq_ovqat VALUES (1, 'Palov’, ‘Xod-dog’,’hech qaysi’);
INSERT INTO oziq_ovqat VALUES (2, 'Sho’rva’, ‘SHI’,’hech qaysi’);
INSERT INTO oziq_ovqat VALUES (3, 'Mastava’, ‘Gamburger’,’hech qaysi’);
INSERT INTO oziq_ovqat VALUES (4, 'Somsa’, ‘Shaurma’,’hech qaysi’);


9-jadval. “Ko’ngilochar xizmatlar” jadvaliga INSERT operatori yordamida yozuv qo’shish
INSERT INTO kongilochar_xizmatlar VALUES (1, 'Basketbol’, ‘Teatr', 'Kino',
‘Basseyn’, ‘Ziyoratgohlarga sayohat’);

INSERT INTO kongilochar_xizmatlar VALUES (2, 'Volleybol’, ‘Teatr', 'Kino',

‘Basseyn’, ‘Muzeyga sayohat’);

INSERT INTO kongilochar_xizmatlar VALUES (3, 'Futbol’, ‘Teatr', 'Kino',

‘Basseyn’, ‘qadimiy qadamjolarga sayohat’);

INSERT INTO kongilochar_xizmatlar VALUES (4, 'Qo’l to’pi’, ‘Teatr', 'Kino',

‘Basseyn’, ‘Dam olish’);

10-jadval. “Restaurant” jadvaliga INSERT operatori yordamida yozuv qo’shish
INSERT INTO restaurant VALUES (1, 'Bog’ishamol restorani’, ‘qimmat', 100);

INSERT INTO restaurant VALUES (2, 'Rohat restorani’, ‘arzon', 50);

INSERT INTO restaurant VALUES (3, 'Nurli Bog; restorani’, ‘arzon', 80);

INSERT INTO restaurant VALUES (4, 'Gulobod restorani’, ‘qimmat', 150);

11-jadval. “Mijoz” jadvaliga INSERT operatori yordamida yozuv qo’shish

INSERT INTO mijoz VALUES (1,‘Abdullayev’, ‘Abbos’, ‘Toshkent shahri’, ‘[e-mail]’);

INSERT INTO mijoz VALUES (2,Qosimov’, ‘Doston’, ‘Samarqand shahri’, ‘[e-mail]’);

INSERT INTO mijoz VALUES (3,‘Umarov’, ‘Farhod’, ‘Andijon viloyati’, ‘[e-mail]’);

INSERT INTO mijoz VALUES (4,‘Sanaev’, ‘Anvar’, ‘Kattaqo’rg’on shahri’, ‘[e-mail]’);