6.2. SQL tili orqali jadvallarga yangi ma’lumot qo’shish. Relatsion model(3-topshiriq)da hosil qilingan jadvallarga INSERT operatori orqali har biriga 15 ta dan ma’lumot qo’shing.
1.About TTJ
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Beshinchi sonli yotoqxona","Samarqand shahar","Shahzod","+998933092077")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Birinchi sonli yotoqxona","Samarqand shahar","Jasur","+998935827177")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Ikkinchi sonli yotoqxona","Samarqand shahar","Ruslan","+998942855477")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Uchinchi sonli yotoqxona","Samarqand shahar","Alisher","+9983388393")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Tortinchi sonli yotoqxona","Samarqand shahar","Alijon","+998331103610")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Tortinchi sonli yotoqxona","Samarqand shahar","Faxriddin","+99890505")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Oltinchi sonli yotoqxona","Samarqand shahar","Aloxon","+998937030039")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Oltinchi sonli yotoqxona","Samarqand shahar","Diyora","+9989933031177")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Oltinchi sonli yotoqxona","Samarqand shahar","Abdurahmon","+998883910304")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Beshinchi sonli yotoqxona","Samarqand shahar","Akobir","+998932372376")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Beshinchi sonli yotoqxona","Samarqand shahar","Javlon","+9989973272736")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Yettinchi sonli yotoqxona","Samarqand shahar","Muslimbek","+998930541798")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Yettinchi sonli yotoqxona","Samarqand shahar","Mavlon","+998931233124")
INSERT INTO about_TTJ( `Name`, `AdDress`, `Komendat`, `phone`) VALUES ("Yettinchi sonli yotoqxona","Samarqand shahar","Sherbek","+998940104355")
2.Book-keeping
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("11000$","1000$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("5000$","500$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("4000$","400$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("3000$","300$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("2000$","200$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("1000$","100$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("500$","50$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("400$","40$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("6000$","600$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("7000$","700$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("8000$","800$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("8000$","800$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("9000$","90$")
INSERT INTO Book_keeping(`Salary`, `Outlay`) VALUES ("25000$","5000$")
Do'stlaringiz bilan baham: |