PointOfSale_BackEnd/SqlQuery.sql at main · fraxhost/PointOfSale_BackEnd · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
INSERT INTO Products (Pid, Category, Fit, Size, Price) VALUES (tr_1, trouser, regular, xl, 500);
INSERT INTO Products (Pid, Category, Fit, Size, Price) VALUES (pm_1, pajama, regular, xl, 700);
INSERT INTO Products (Pid, Category, Fit, Size, Price) VALUES (pt_1, pant, regular, xl, 1000);
INSERT INTO Products (Pid, Category, Fit, Size, Price) VALUES (ts_1, tshirt, regular, xl, 500);
INSERT INTO Products (Pid, Category, Fit, Size, Price) VALUES (sh_1, shirt, regular, xl, 1000);
INSERT INTO Products (Pid, Category, Fit, Size, Price) VALUES (pb_1, panjabi, regular, xl, 1500);

INSERT INTO Products (Pid, Category, Fit, Size, Price) VALUES (tr_2, trouser, regular, xl, 500);
INSERT INTO Products (Pid, Category, Fit, Size, Price) VALUES (pm_2, pajama, regular, xl, 700);
INSERT INTO Products (Pid, Category, Fit, Size, Price) VALUES (pt_2, pant, regular, xl, 1000);
INSERT INTO Products (Pid, Category, Fit, Size, Price) VALUES (ts_2, tshirt, regular, xl, 500);
INSERT INTO Products (Pid, Category, Fit, Size, Price) VALUES (sh_2, shirt, regular, xl, 1000);
INSERT INTO Products (Pid, Category, Fit, Size, Price) VALUES (pb_2, panjabi, regular, xl, 1500);